I'd like to be able to have conditional formatting for my data labels in line charts, bar charts, funnel etc. A great example for this would be to highlight positive and negative values in a bar or linechart, by having negative values represented by red data labels. I know that it's possible to conditionally format the color of the bars in a bar chart but it would be nice to have this be possible for the data labels as well.
6 Comments
- Must required. Easy to highlight achieved and not achieved figure in chart.
- Conditionally format the label type as well using the FORMAT function
- Please share this idea with others :) I'm surprised this isn't a standard feature. It's ironic that we can use conditional formatting on text, lines, backgrounds, borders, and *values in tables*, but not on *values in a data label* ? Why for all those and not the other ? Seems like the logic is already built in. It just needs to be extend it universally, across every element, especially data labels.
- agree! I posted a bug report since this should be possible in the august-update, but it isn't: https://community.powerbi.com/t5/Issues/Conditional-formatting-for-Data-label-colors-at-line-level/idi-p/2032406
Isnt it already possible (02 FEB 2022) from the Data Label formatting ?
I agree that some improvements are still missing e.g. if I want to see only last value of a chart.
- Status added:Needs Votes
