Forum Discussion
Power BI visual
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.
Thanks a lot Shaurya, this worked. Appreciate it.
4 Replies
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.Thank you for responding. Let me try that.
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 ForecastsThanks a lot Shaurya, this worked. Appreciate it.
