Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis is superb. Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |