Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Dear All,
Im trying to format data labels that are already in %, to color negative numbers red and positive green. (Power Bi Desktop)
The selection of number and percentage is blocked, number is grayed out.
I tried the solution below but does not work, it displays all numbers as red.
I would appreciate if someone could help me with this issue.
Thanks in advance
I use Power Bi Desktop June 2022 version
Hi , amitchandak thank you for your answer.
Im not an expert, but what do you mean with row values?
Those values are the total QoQ% difference between years coming from a quick measure.
@Angel22 , You are expecting color based on the bar(row) value. and I doubt that label formatting as of now works with overall value. Plot this measure on card visual and check does it follow that value.
Also, check the condition on the Value/bar formatting and check
Hi , amitchandak
Creating a card visual and trying exactly the same parameters that i used for the data labels (but in effect - background) works perfectly.
So i dont get why it should not work for the data labels if the variables are the same.
Ok perfect, i reported it as an issue
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
68 | |
53 | |
53 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
55 | |
45 | |
43 |