Forum Discussion
mel3948
3 years agoFrequent Visitor
Applying custom label to ribbon chart
Hi, I know that I had already posted something similar to this, but I am having trouble applying custom label to the ribbon chart.
I have a ribbon chart looks like this, and I’d like to add red x marks to it, to which indicate the scores that are below the baseline score.
* Baseline score for each category: Category 1: 75 pts, Category 2: 78 pts, Category 3: 75 pts, and Category 4: 70 pts.
I tried using switch fuction and came up with this:
category baseline score =
SWITCH(
"Category 1" & SUM('Sheet3'[Scores]) < 75, "❌" & FORMAT(SUM('Sheet3'[Scores]), "#.00"),
"Category 2" & SUM('Sheet3'[Scores]) < 78, "❌" & FORMAT(SUM('Sheet3'[Scores]), "#.00"),
"Category 3" & SUM('Sheet3'[Scores]) < 75, "❌" & FORMAT(SUM('Sheet3'[Scores]), "#.00"),
"Category 4" & SUM('Sheet3'[Scores]) < 70, "❌" & FORMAT(SUM('Sheet3'[Scores]), "#.00"),
FORMAT(SUM('Sheet3'[Scores]), "#.00")
)
But I got error message saing "can't display the visual" when applying this to custom label.
I am not so sure which part went wrong. Any help is appreciated 🙂
1 Reply
- lbendlin
Super User
You may want to consider using a line chart. There you can add a constant line for the baseline.