Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I have the above dataset with two fields, QTR GTN % and QTR CV %
I need to create a slicer with these two columns with specific conditions for each.
For example, if I click on QTR GTN %, it will subset by table above to all rows with a QTR GTN % > 0.4 or QTR GTN % <-0.4.
If I click on QTR CV %, it will subset by table above to all rows with a QTR CV % > 0.1 or QTR GTN % <-0.1.
Once I make the selection on my slicer I want my graph of unique sales_doc_numbers by profit center to also change based on the new subset table. How do I do this?
@Anonymous think you can create a dim table and use it in a slicer, then use Switch or IF to control you calculation
or create a calculation group
@wdx223_Daniel Do you think you could provide a sample code on how to do this. I have tried to create another unrelated table and add a measure with an if statement but it's not working for me
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |