Creating Different Visual

[meIdo]

Hi Guys,

I have a table which contains optimal value and months where the value either rises or falls below optimal value. I have used Slicer to filter specific Metrics. I have attached a picture below for clear explanation. 

[v-xiaosun-msft · Accepted solution]

Hi @meIdo ,

According to your description, here is my suggestion.

When you use a histogram, the central axis always start at 0. I think if you want to see which month is above or below the baseline, you might as well do a subtraction. Please follow these steps.

Create measures.

July = MAX('Table'[Jul])-MAX('Table'[Baseline])

Augest = MAX('Table'[Agu])-MAX('Table'[Baseline])

September = MAX('Table'[Sep])-MAX('Table'[Baseline])

When the value is positive, it means that the baseline is exceeded, and when the value is nagative, it means that it is below the baseline.

Final Output:

Or you can use EXCEL to add a baseline and please refer to the following link which may be helpful to you.

How to add horizontal benchmark/target/base line in an Excel chart? (extendoffice.com)

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.