Display median value in column chart

Anonymous 

To display the median and average values of project delay in the bar chart, you can follow these steps in Power BI:

1. **Calculate Median and Average**: First, you need to calculate the median and average values of project delay. You can do this using DAX measures. Here's how you can calculate them:

```DAX
Median Delay = MEDIAN('YourTable'[Delay])

Average Delay = AVERAGE('YourTable'[Delay])
```

Replace `'YourTable'` with the actual name of your table and `'Delay'` with the name of your delay column.

2. **Create Bar Chart**: Create a bar chart visual in Power BI and add your project names to the Axis and project delays to the Values section.

3. **Add Median and Average Lines**: To add median and average lines to the chart, follow these steps:

a. Go to the formatting options of the bar chart visual.

b. Navigate to the "Data colors" section.

c. Click on the "+" button to add a new rule.

d. Choose "Median Delay" from the dropdown menu.

e. Set the color to differentiate the median line from the other bars.

f. Repeat steps c to e for the "Average Delay".

This will add median and average lines to your bar chart, making it easy to visualize these values alongside your project delays. You can customize the appearance of these lines to make them stand out, such as using different colors or line styles.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!