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

[abhishekpati86]

Hi All,

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

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.

[abhishekpati86]

@Greg_Deckler , @MattAllington, @ankitpatira

[MattAllington]

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/

[abhishekpati86]

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 ?

[v-haibl-msft]

@abhishekpati86

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

Best Regards,

Herbert

[abhishekpati86]

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

[MattAllington]

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