The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm brand new and no pretty much nothing so bear with me.
So I made a measure to track how many times each job posting was in my data. As you can see I added that measure to a table and it works perfectly. I attached a screenshot of how that measure was made. I also made a filter so the table will only display jobs that have more than X amount in the Total Listings measure.I added a screenshot of how I did that.
2 things, first off, it doesn't work super well. Say I adjust the slider to be above 20 jobs, some with only 1 or 2 listings will still get through. Also, the main thing, I want the filter to have check boxes that say "20+", "30+", "40+", etc. I don't want it to be a Slider. How can I make the Count Filter work like that instead of a slider?
Hi @JordanSchuld ,
Based on my testing, please try the following methods:
1.Create the simple table.
2.Create the calculated column.
Count Listing =
SWITCH(
TRUE(),
[Total listing] >= 40, "40+",
[Total listing] >= 30, "30+",
[Total listing] >= 20, "20+",
"Under 20"
)
3.Drag the column into the slicer visual.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So I tried this, but it shows eveything as Under 20.
Here is my Count Listings:
And here is my table:
Not sure what I'm doing wrong, any insight?
Power BI does not support dynamic binning - you need to bring your own buckets (a disconnected table) to feed your slicer. Then use the measure to sense the value of the slicer (make sure it is single value select).
I'm going to be honest with you, this is jiberish to me lol. I'm so new to Power Bi it's not funny.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
33 | |
20 | |
17 | |
15 |
User | Count |
---|---|
56 | |
50 | |
36 | |
35 | |
28 |