Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
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/
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 ?
Have you got this problem solved with MattAllington’s suggestion?
Best Regards,
Herbert
You could use banding http://exceleratorbi.com.au/banding-in-dax/
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |