Power BI visual

[dan1234]

 

Hi all,

Posting to get some help in a problem.

I have a requirement to create a chart like one attached  in Power BI.

The graph says which category has the highest value for a metric and the metric got three thresholds to calculate their state as in " Good" , "Needs Improvement " and "Bad".

Good = if ( metric is >= 98%)

Needs Improvement = if ( metric is > 85% and < 98%)

Bad = if ( Metric is < 85%)

The idea is to look at the graph for a point in time and be able to say clearly which category is performing well and bad etc.

Is it possible to create a graph in Power BI like that?

I am trying to use clustered chart and play around but can't make the the threshold scenario to work. Any help would be much appreciated.

[Shaurya]

Hi @dan1234,

Create constant line in your visual. You can directly give the values for your category limits or use field value option to use a measure that has calculated your category limit.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[dan1234 · Accepted solution]

Thanks a lot Shaurya, this worked. Appreciate it.

[mangaus1111]

Hi @dan1234 ,

maybe something like this. 

In the legend you have to put the below calculated column:

Status =

SWITCH(

       TRUE(),

        [Sum]>= 0.98, "Good",

        [Sum]< 0.85, "Bad",

        "Needs Improvement"

)  

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

[dan1234]

Thank you for responding. Let me try that.