Forum Discussion
puru85
2 years agoHelper II
Multi-Select Measures in Line Chart
Hello Experts, I have a requirement to display default measures, "Total Sales" and "Total Profit," in a Line chart, which I have successfully achieved. Additionally, I am able to dynamicall...
- 2 years ago
puru85 you can easily achieve this with field parameters, see attached. Check field parameters related videos on my YT channel.
- Anonymous2 years ago
Hi puru85 ,
Thanks for mh2587 and parry2k reply.
Here's what I want to add:
Create a Filed ParameterCreate a column in Parameter table
Measure Name = IF( Parameter[Parameter] = "Discount", "Discount", "Qty" )
Create relationship between "Parameter[Measure Name]" and “Dynamic Measure[Measures]”Create a measure
Measure = IF( SELECTEDVALUE('Dynamic Data'[Measures]) IN VALUES(Parameter[Measure Name]), 1, 0 )Slicer settings
In line cahrt field use "Total profit","Total Sales",“Parameter”Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
mh2587
2 years agoSuper User
You need new field Parameter for that