Pass a text parameter in report

Anonymous,

What if parameter is not suitable for your scenario.

In your scenario, create a new table containing the measure name(Quality, Sales Amount, Margin). Add the column of this new table into a slicer so that you can select which measure to display.

And in your original table, you would need to create a measure using the formula below, for more details, please review this blog: http://breaking-bi.blogspot.sg/2016/06/power-bipowerpivot-using-slicers-to.html .

selected measure = IF(HASONEVALUE(NewTable[Column]),SWITCH(FIRSTNONBLANK(NewTable[Column],NewTable[Column]),"Quality",SUM(OriginalTable[Quality]),"Sales Amount",SUM(OriginalTable[Sales]), "Margin",SUM(OriginalTable[Margin])),blank())

Regards,
Lydia