Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Slicer for Multiple Measures

Hi All,

I have a  Slicer that dynamically selects Measures.I was able to achive this for a Single Measure but now i have to display 4 measures when single measure is selectedin slicer .How do I achive this.?

Eg:when Count of Items is selected in the slicer,the graph should display 4 measure(one month Avg,two month avg....) line need to displayed.  for Count of Items


I was able to do it for single measure and single calculation using the below


Steps done so far:

1)Create a table with measure to be displayed in Slicer.

2) Create a  Measure column for 1 Month Avg (which Includes switch for the 6 measure) as shown below

SWITCH([Selected Measure Avg],[Item Count ],CALCULATE(SUM(Tab1[c1]),(T1[c2]>0),

[Product Countl],............),

3)Replicated the same for 3 month Avg ,6month Avg and 12 month Avg..........


When i select Item count in slicer,I get only only one line showing the 1 month avg...







Community Support
Community Support

Hi @Rtum ,


I think this scenario is currently not supported.

In SWITCH(), one  condition has one value. And measure  always returns a single value.

=SWITCH(MAX('Selection'),"1 Month",[M1],"2 Month",[M2])


Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

@Rtum ,Based on what I got

That means 4 measure has to be created using the measure slicer


So 4 measure has use the value of slicer

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Yes, when i select  Item Count from Slicer,I need the graph below to show me four lines (1Month Avg,3 Month Avg,6 month Avg,12 month avg)....


I created 4 measures(one for each month Avg) using switch ( for 6 slicer measures)...anything i am missing?

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors