The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I'm trying to set the colour of a chart's data label and/or X axis label via a measure but find that the labels are always set to the same colour.
The same measure applied as conditional formatting in a table applies the correct colour though.
Here's how a simplified example looks - pbix linked below btw:
Data:
ReportMonth | ID | Actual | Target |
01/01/2022 | 1 | 5 | 10 |
01/01/2022 | 2 | 3 | 10 |
01/02/2022 | 3 | 8 | 10 |
01/02/2022 | 4 | 7 | 10 |
01/03/2022 | 5 | 9 | 20 |
01/03/2022 | 6 | 8 | 20 |
01/04/2022 | 7 | 12 | 20 |
01/04/2022 | 8 | 15 | 20 |
the measure is:
Label Colour =
IF ( SUM ( MyTable[Actual] ) >= MAX ( MyTable[Target] ), "Green", "Red" )
any help/guidance appreciated
Still not supported. Vote for the idea.