how to add measure(percentage) in slicer?

[Anonymous]

Hello folks,

I have created a new measure using the below function,

X = DIVIDE( [delta] , SUM(XYZ[prior period]) )

value range => -120% to 135%

I want to put this measure in a slicer for the user. I tried to use GENERATESERIES but it is not working. Any quick resolution is very much appreciated. 

Note that, the slicer should be for percentage calcluation.

Best,

Rittick

[v-lionel-msft]

Hi @Anonymous ,

We can't put measures in a slicer, you can create a what if parameter and put the parameter column in a slicer.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You need to create an independent table and use that in a measure,

Please watch my video, file link is there is the description : https://www.youtube.com/watch?v=CuczXPj0N-k

[Anonymous]

@amitchandak  thanks for your reply. Appreciate your help. 

But I want to use a slicer on '%margin' (As per your video) and use it to filter the whole dataset(Name, % margin as per your view on the video). I didn't get this from your video. Appreciate if you have any solution for this please.

Thanks a lot for your time. 

[amitchandak]

@Anonymous , This what basically happens. When try to bucket the measure we need a level or group, In my case, I used customer id. Now if need at line level then better to have column and bucket, means static segmentation 

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/

So if I want very line the margin % to bucket better to have a column. But when bucket customers based on margin then I need Dynamic segmentation, and now customer Id is my base which I used in values in the formula.

Hope this helps.

else Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.