Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Vikas_J
Regular Visitor

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.

 

You can imagine it to be Matrix of 10 projects in rows and Months of year in  columns with values being numerical enteries against each month and each project. 

 

I created a table of 12 measures(aggregate of values in Month column)  for each of the month. 

 

Then another measure is created to use Switch statement to select data based on user selection. 

 

Using these i am trying to create a visulization of stacked column for each project. WIth column value being numerical entry against the selected month from the slicer. 

 

so for all 10 projects if user selection is January the visualization should display numerical data for all projects for month of January. So far so good. I am able to make it work till this step. 

 

However when i try to make multiple selections in the slicer( January + February + March ) data, the visualizaiton goes blank.

Vikas_J_0-1712744554720.pngVikas_J_1-1712744601276.png

 

 

Vikas_J_2-1712744642053.png 

Vikas_J_3-1712744678705.png

 

 

Any help / resource on this will be very helpful please.  

1 ACCEPTED SOLUTION
HarishKM
Impactful Individual
Impactful Individual

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

HarishKM_0-1712904130759.png

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!

 

 

View solution in original post

4 REPLIES 4
HarishKM
Impactful Individual
Impactful Individual

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

HarishKM_0-1712904130759.png

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!

 

 

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.!

Vikas_J
Regular Visitor

Thankyou Audrey. However i am little new to Power Bi. 

I am not able to follow you here. can you please elaborate or direct me to some similar example/ short video for such a task. 

 

I am not sure what you mean "instead of separate measures, can you make one measure" one measure of what?

 

Thankyou for helping.

audreygerred
Super User
Super User

Hello! Instead of having a separate measure for each month, can you make one measure and put that in the values well of your matrix, months in the columns, and your projects in the rows. Then, when you select three months you will see the individual amounts for each month as well as the total of them.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.