Filtering on all pages using a measure - Live Connection

[Anonymous]

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

[Anonymous]

UP

[amitchandak]

@Anonymous , 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/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[Anonymous]

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