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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
6 | |
3 | |
3 | |
3 |
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |