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
- mangaus1111
Solution Sage
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.
- Shaurya
Memorable Member
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.
