Forum Discussion
RafaelAri
Helper III
Helper IIISelect different measures by slicer
Hello to all experts, I have a Matrix table, containing 16 different columns, each column displays a specific measure, from a Measure-Table. One of the columns should have the option to display dat...
Hi RafaelAri
It sounds like a classic scenario for field parameters.
Please check the linked guide :
https://www.youtube.com/watch?v=-nqEv2YXLsUIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
DataNinja777
Super User
Super UserHi RafaelAri
You can achive your required output by transposing or unpivoting the 16 column measure table, and transform the wide table to a long table like below, and have it as a disconnected table with your fact table, and then use the measure field as the slicer, and write a switch function to link the selected measure to your slicer choice, (or use selectedmeasure function.)
Selected Measure = switch(min('Slicer'[#]),1,[Measure A],2,[Measure B],3,[Measure C].... and so on)
| # | Measure |
| 1 | Measure A |
| 2 | Measure B |
| 3 | Measure C |
| 4 | Measure D |
| 5 | Measure E |
| 6 | Measure F |
| 7 | Measure G |
| 8 | Measure H |
| 9 | Measure I |
| 10 | Measure J |
| 11 | Measure K |
| 12 | Measure L |
| 13 | Measure M |
| 14 | Measure N |
| 15 | Measure O |
| 16 | Measure P |
Best regards,