Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
abhishekpati86
Helper III
Helper III

How to get a custom range filter based on the count of the column

Hi All,

 

I have the following structure of the course + due date on the axis and Count on the value side.

 

Capture.JPG

 

I want to create a custom filter for the count as I have 100 + combination of Course+ due date and it doesn't make any sense for anyone to keep scrolling down. 

 

I want a custom filter/slicer with something like the below structure - 

1. <20 

2. >20 <50 

3. >50 <100

4. >100 <1000

5. >1000

 

Is it possible to do it ?

 

Thanks.

 

 

6 REPLIES 6
abhishekpati86
Helper III
Helper III

You can use conditional columns when you load the data.  I have a blog article about it here 

http://exceleratorbi.com.au/conditional-columns-power-bi-desktop/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Hi,

 

But my column is a calculated field and I don't have it as another column in my table.

 

1. Count_course_week_due = COUNTA('Table',[Course-Due_Date])

2. Course-Due_Date = Concatenating Course and Due Date column.

 

Can you let me know if there is any other way around for this ?

@abhishekpati86

 

Have you got this problem solved with MattAllington’s suggestion?

 

Best Regards,

Herbert

@v-haibl-msft -- I haven't tried that yet.

You could use banding http://exceleratorbi.com.au/banding-in-dax/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.