Forum Discussion

Impactful Individual

9 years ago

Solved

Dynamic Visual Caters Multiple Measures

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

Need Help

v-sihou-msft
9 years ago
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,

v-sihou-msft

Microsoft Employee

9 years ago

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,

Forum Discussion

Dynamic Visual Caters Multiple Measures

Related content

Dynamic measure filtering

Dynamic Measure developement

Multiple measures in matrix by year

Dynamic Filter creation based on multiple criteria

How to show multiple metrics/measures in a visual?