Forum Discussion
daniellamoore29
Helper I
Helper IMatrix table and stacked bar chart
I have a matrix which identifies the financial year and quarter, the indicator value, variance threshold (amber RAG status), and target.
I want to show the row as a bar chart, so
1. show RED if indicator value is < variance threshold
2. show Amber if inidcator value is >= variance threshold & < target
3. show Green if inidcator value is >= target
How would I show this please?
Hello,
To solve this I would try to create a DAX measure and to use it as a legend in the chart.
You should try to make a DAX like this :Color = IF([Indicator Value] < [Variance Threshold], "Red", IF(AND([Indicator Value] >= [Variance Threshold], [Indicator Value] < [Target]), "Amber", "Green"))Igna
1 Reply
- Igna
Resolver III
Hello,
To solve this I would try to create a DAX measure and to use it as a legend in the chart.
You should try to make a DAX like this :Color = IF([Indicator Value] < [Variance Threshold], "Red", IF(AND([Indicator Value] >= [Variance Threshold], [Indicator Value] < [Target]), "Amber", "Green"))Igna