cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

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

Super User
Super User

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

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted

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

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 ?

Super User
Super User

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

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



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
v-haibl-msft Super Contributor
Super Contributor

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

@abhishekpati86

 

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

 

Best Regards,

Herbert

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

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