Forum Discussion

Vikas_J's avatar
Vikas_J
Frequent Visitor
2 years ago
Solved

Using table of measures in slicer to dynamically select visualization

Hello,    i am facing issue with using measures as a slicer option.    Te problem is very simple. I have numerical data for each month of the year againt a list of projects my team is working on....
Need Help
HarishKM's avatar
HarishKM
Icon for Super User rankSuper User
2 years ago

Vikas_J Hey Vikas,
you can use field parameter funcationality of power bi to get it done. It will something like this...

Step 1: Create a field parameter with your choice of measure

Step 2: Drag that new parameter to slicer and as well as table to get desire output.

 

further read : Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

 

Thanks

Harish

Did I answer your question? Kindly give kudos and Mark my post as a solution!

 

 

Vikas_J's avatar
Vikas_J
Frequent Visitor
2 years ago

Hello Harish,

 

Thanks for the methodology. However i tried another way . Unpivoted all the columns in single column and worked with that. i was able to get the desired results.

 

Thanks for your help.!