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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
50 | |
49 |
User | Count |
---|---|
163 | |
85 | |
76 | |
68 | |
67 |