Putting Measures in a filter

[jayjani]

Hello,

I have multiple measures such as Net Margin, Gross Margin, Factory Margin, etc.

Now I want to create a line or area chart that shows year over year trend for any one of these measures.I just want one chart and one measure to be included at a time.

So, I want to create a filter comprising of all these measures such that when I select Net Margin, the chart will show Net Margin trend only. Is there a way I could do that?

[MFelix · Accepted solution]

Hi @jayjani ,

You need to create a table with the names of your measures, this table needs to be unrelated with all other tables.

Use the previous table as a slicer in your report now create the following measure:

Selected Measure =
SWITCH(SELECTEDVALUE(Table[Measurename]);
"Net Margin"; [Net Margin];
"Gross Margin"; [Gross Margin];
...,
[Measure you want as defaul]
)

Now use this measure on your  area chart and make sure that the slicer is set to single select shoudl give expected result.

The lasst measure should be the one you want has default if there is no selection.

[jayjani]

This is superb. Thank you!