Skip to main content

Analytics

How to show multiple measures in single visual from slicer selection in Power BI

Data Analyst Working On Business Analytics Dashboard With Charts, Metrics And Kpi To Analyze Performance And Create Insight Reports For Operations Management.

Power BI is a Business Intelligence tool used to create Interactive Dashboards which helps the Business users to analyze their data insights. In Power BI, to show calculations measures are built, and it is used to represent the data on dashboard. Slicers in Power BI are the simple forms of filters that play a key role in designing customized charts. let’s see how we can use multiple measures in one visual using slicer selection.

Steps:

  1. Create your measures like total Quantity, Total sales which can be used in your switching measure calculation.

Ex:1) Total Quantity = CALCULATE (SUM (Orders [Quantity]), USERELATIONSHIP (Orders [Order Date], Calendar [Date]))

2)Total Orders = CALCULATE (DISTINCTCOUNT (Orders [Order ID]), USERELATIONSHIP (Orders [Order Date], Calendar [Date]))

  1. Create a table for slicer that should contain your measure names. And use this column as your slicer to display the measure in visual.

Picture1

 

  1. Create a switch measure calculation which will be used in values in your visual.

Picture2

Now in this calculation we are basically saying that if, Total Orders are selected in slicer then show us Total orders and if Total Quantity is selected then show Quantity.

  1. We can dynamically change the title of visual as per selection on slicer by using the below measure.

Picture3

  1. Use this measure in title in formatting pane using function. For reference see below screenshot.

Picture4Picture5

  1. Take bar chart in your canvas and place your measure in values and date in your axis and place slicer visual on your canvas and drag the column which we created from the table in which we are having the measure names.

Picture 8

Picture9

This is how we can show multiple measures in a single visual in Power BI.

Thoughts on “How to show multiple measures in single visual from slicer selection in Power BI”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Anshika Bajpai

Anshika Bajpai is an Associate Technical Consultant at Perficient Nagpur GDC. She is a Power BI developer having one year of Experience in Power BI. She likes to share her knowledge and is open to suggestions as well.

More from this Author

Categories
Follow Us