How to use Median Line in Analytics Pane in power bi
This recipe helps you use Median Line in Analytics Pane in power bi
Recipe Objective - How to Use Median Line of Analytics Pane in Power BI?
Task - Find out which subcategories generate Profit greater than the overall Median Profit in a bar graph.
Access Avocado Machine Learning Project for Price Prediction
Table of Contents
Step 1 - Open Power BI report
Step 2 - Add the 'Bar graph' visual in the Power BI report.
To add 'Bar graph,' go to Visualization pane -> Drag and drop 'Bar graph' visual in Power BI report.
Step 3 - Add fields into the 'Bar graph' visual.
Put 'Sub-Category' in Axis field and 'Profit' in Values field.
Step 4 - Add Median Line on 'Bar graph' visual
Select visual, go to Visualization Area -> Analytics -> Median Line -> Add.
This will make the Median line, all the Sub-Categories whose bar exceeds the Median line, generate Profit greater than the overall Median Profit.
In this way, we can add Median Line in the Power BI report.
Download Materials
What Users are saying..
Ameeruddin Mohammed
I come from a background in Marketing and Analytics and when I developed an interest in Machine Learning algorithms, I did multiple in-class courses from reputed institutions though I got good... Read More