Forum Discussion
Conditional Formatting Data Labels
- 6 years ago
Hi Anonymous ,
You cannot condittional formatting data labels however you can make a work around:
Create 3 measures:
Total Values = SUM(Table[Column]) Total Values Above = IF([Total Values] < 100; BLANK(); [Total Values] ) Total Values Below= IF([Total Values] < 100; [Total Values] ;BLANK()) āNow add your measure to the line chart and make the following setup:
Turn of the lines on the Values above and below
Turn off data labels on the Total Values measure
Make different formatting for labels for lines above and below
Adjust the measure to what you need if you want to have additional levels you need to create additional measures.
Check PBIX file attach.
I sympathize with this issue. Here's an example. Data labels for certain values can show up as 0.0K, but having all data labels in raw units just looks crowded (ie. 4.2K > 4,200 and 144 > 0.1K). There should be conditional formatting for units as there is for color.
I submitted an idea ticket: https://ideas.powerbi.com/ideas/idea/?ideaid=10ba158d-4e13-ed11-b5cf-281878bd0909