Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two different amount columns, one for cleared, one for discrepant, and I want to create a slicer to show only the records with a discrepant amount. Most of the time it's an either/or scenario, but there is a small population that has values for both.
I tried using a calculated column as a helper to drive the slicer, but then if you select the "No" option, it will remove the last line and give the wrong total for the "Cleared" column.
And if I change the "No" to being blank, then the slicer has the "(Blank)" option, which I'd prefer not to have so as not to confuse end users.
Ideally, the slicer would look more like this, being closer to a toggle. Is that even possible?
Solved! Go to Solution.
Sure. Edit the visual level filter on your slicer, and set it so that it only displays values where [Discrepant?] = "Yes"
Sure. Edit the visual level filter on your slicer, and set it so that it only displays values where [Discrepant?] = "Yes"
Wow. I feel dumb.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
96 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |