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 Power BI Community,
I would like to use Switch True DAX to select metric to show the necessary data depending on the needs.
For instance, if a user selects "Sales", the dashboard will show the sales data
and if the user selects "Costs", the dashboard will show the cost data.
Please refer to below YouTube video and this is exactly what I would like to do.
I understand how to set up Switch True DAX from this video, but what I do not understand is
how this guy set up [metrics selected] measure.
Can anyone guess how to set up this measure?
Thanks,
H
Solved! Go to Solution.
Create a table as below with values as Sales, Costs, etc and use them as a slicer.
Sales
Costs
In your switch measure, use a variable to get the selected value and use in place of "Metric Selected"
Var selected_value = SELECTEDVALUE(COLUMN) //Slicer column)
If it helps mark it as a solution
Kudos are nice too
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |