Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello, guys.
I'm working with a live connection to a SQL Server Analysis Services database and trying to add a filter on all dashboard pages. The filter would be by the measure "Baseline".
I'd like the filter "Baseline>0" applied to all the visuals, but I cannot figure out how to make it work since I can't use a measure in a slicer, and cannot add any new tables to my model or modify the existing ones.
Any thoughts?
Thank you,
Henrique
UP
@HSobral , Measure can be used as a visual level filter only, You can try dynamic bucketing to make a dimension, but then I measure have to use that bucket
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Thank you for the response, Amit.
The thing is that I cannot upload any data into the model because it is a live connection dashboard, so I cannot create the "Bucket" table.
Any other way around?
Thx in advance
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
107 | |
68 | |
48 | |
44 | |
43 |