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.
hi there,
Currently seems that slicer can only select the items contain in one column, it that possible to select different measure? for example, I want to switch item in the visuals between sales and GP (2 measures), when I click "sales" all visuals changed to sales value. I think there is a solution to copy 1 set of data, create a column differentiate 2 items-sales and GP, but it will make the data model size much bigger.
I wondered if it is possible to create a slicer to switch the value between "sales" and "GP" from 2 measure, then no need to revise the data model. thanks
Best regards,
ER
Solved! Go to Solution.
Hi @erihsehc
Please find the link to my blog post below.
https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
Hi @erihsehc
THis is most certainly possible.
I am going to blog about it next week, with detailed steps on how to do it, as there are quite a few steps to follow but not too complex.
Selected Measure = VAR MySelection = SELECTEDVALUE ( 'Measure Selection'[Measure Name], "Sales" ) RETURN SWITCH ( TRUE (), MySelection = "Sales", [Sales], MySelection = "Costs", [Costs], MySelection = "Margin", [Margin], [Sales] )
Thanks @GilbertQ. Would you paste the link of the blog below when the detailed instruction is available? it is a bit complicated to apply this trick. It is amazing
Hi @erihsehc
Please find the link to my blog post below.
https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
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.