Making measures selectable in slicers

[Casperserven1]

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.

[Anonymous]

Hi @Casperserven1 ,

Thanks for your nice sharing.

It's a useful little trick!

Best Regards,

Stephen Tao

[some_bih]

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