Dynamic Visual Caters Multiple Measures

[ovetteabejuela]

Is it possible to make 1 visual cater multiple measures?

For example, if I have a slicer for different Meassure:

Measure 1: Attendance

Measure 2: Sales Leads

Measure 3: Processing Rate

and then 1 have just 1 visual(a line chart for example)

and if I click on Measure 1, the visual displays data for Attendance

                         Measure 2 displays data for Sales Lead

                         Measure 3 for Processing Rate.

[v-sihou-msft · Accepted solution]

@ovetteabejuela

Firstly, you need to create a measure table for populating slicer. Then you can create a "Common Measure" to switch different calculation based on your selection in slicer so that you just need to put this "Common Measure" into chart visual. For more details, please refer to articles below:

http://breaking-bi.blogspot.sg/2016/06/power-bipowerpivot-using-slicers-to.html

http://visualbi.com/blogs/powerbi/dynamic-measure-selection-power-bi/

http://sqljason.com/2012/11/measure-selection-using-slicers-in.html

Regards,