Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |