Using a Gross Margin Percentage Measure as a Slicer

[CoopyJoe]

I am trying to create a slicer that lets me use my Gross Margin % measure as a field. Since the value is a measure, it will not let me. I am hoping to create something similar to the default visual level filter, but as an actual page slicer. I have seen a few tutorials on how it can be done with whole sales numbers, but nothing for percentages. Was wondering if anyone was aware of any workarounds.

Thanks!

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[amitchandak]

@CoopyJoe , bucketing, between one using measure, you can make it as small as 1 %

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