Forum Discussion
Display multiple measure values based on slicer selection
Hi All,
The solutions suggested above did not suit my requirement. I was finally able to achieve it by using Field Parameters. This artcile contains the details and the usage of Field Parameters.
https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-charts-and-visualization/field-parameters-and-how-to-use-them-in-power-bi/
Additionally, since I needed the measures to be grouped as per a specific hierarchy, I edited the DAX generated for the Field Parameter table and added an additional column that helped me set-up the hierarchy. The below video has a similar explanation-
https://youtu.be/qlhcN3A0HNU
I now have all my measures in a slicer, arranged in a specific hierarchy. I have one single visual, wherein I can show the value of any of the measures from the slicer, or a group from the slicer.
Hi,
Thanks for the reply. I don't quite follow what you are saying. I already have a table of measures and even a measure for the selection with the SWITCH(). But it doesn't seem to work. Since I can't share the actual data, I have tried to mock my problem with some silly data-
I have two tables as below-
I have a slicer as below-
The measure for the slicer selection is written as below-
When I try to see the value of this MeasureSelection, I always end up with the default value. I don't get the outputs of other cases. What am I missing?
Try with subcategory I mean avoid && condition it often create ambiguity
Do you mean like this?
This won't work for multiple selections. That's the problem with my original question too.