Making measures selectable in slicers

Casperserven1 — Wed, 14 Jun 2023 14:48:57 GMT

Dont know if this is posted anywhere but I had trouble finding it - If you want to make a slicer displaying measures from which you select you can do the following by creating a table:

MeasureList = {

("Agree", NAMEOF('MainMeasures'[Agree]), 1),

("Disagree", NAMEOF('MainMeasures'[Disagree]), 3),

("Neutral", NAMEOF('MainMeasures'[Neutral]), 2),

("Strongly Agree", NAMEOF('MainMeasures'[Strongly Agree]), 0),

("Strongly Disagree", NAMEOF('MainMeasures'[Strongly Disagree]), 4)

}

Create a table using the above syntax the first bit is what appears in your slicer, the second bit is your measure table and measure name and the third bit is the order you want them to appear in. One created you add this to a slicer.

Anyway - hope this is useful to somebody.

Re: Making measures selectable in slicers

some_bih — Thu, 15 Jun 2023 10:09:48 GMT

Hi Casperserven1 check Fields parameters features https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters I hope this help

Re: Making measures selectable in slicers

Anonymous — Mon, 03 Jul 2023 06:19:39 GMT

Hi Casperserven1 ,

Thanks for your nice sharing.

It's a useful little trick!

Best Regards,

Stephen Tao

topic Re: Making measures selectable in slicers in DAX Commands and Tips

Making measures selectable in slicers

Re: Making measures selectable in slicers

Re: Making measures selectable in slicers