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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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.
I will not give you bad advice, even if you unknowingly ask for it.

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.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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