Forum Discussion

SmithaKMurthy's avatar
SmithaKMurthy
New Member
3 years ago
Solved

Display multiple measure values based on slicer selection

Hi All, I have around 15 measures in my model, which I need to show in a visual (line chart). The chart becomes unreadable if I add all of them directly. Hence, I thought of grouping the measures ...
Need Help
Aburar_123's avatar
Aburar_123
Solution Supplier
3 years ago

or you can try like this,

 

HighQuality = switch(true(),max('Measure Category'[Measure Category])="Fruit",[HighQualityFruit],
max('Measure Category'[Measure Category])="Veg",[HighQualityVeg])
 
MostSold = switch(true(),max('Measure Category'[Measure Category])="Fruit",[MostSoldFruit],
max('Measure Category'[Measure Category])="Veg",'Measure Table'[MostSoldVeg])
SmithaKMurthy's avatar
SmithaKMurthy
New Member
3 years ago

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.