Forum Discussion

mel3948's avatar
mel3948
Frequent Visitor
3 years ago

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

  • You may want to consider using a line chart. There you can add a constant line for the baseline.