Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
95 | |
86 | |
76 | |
64 |
User | Count |
---|---|
138 | |
113 | |
109 | |
98 | |
93 |