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.
I have created a DAX logic for getting values based on few logic to measure a metric, where my final result appears both in amounts and percentage and later I bring it this over to a card visual like 'Value above $XXX,XX & YY%' and it appears in black font, is there a way I can format in conditionally so that when it is negative I can make it appear in red and if it is positive it appears in green.
Solved! Go to Solution.
Hi,
You can set Card visual->Format->Data Label->conditional formatting.
I create a simple sample to show.
Create a color measure to check:
Color = IF(SUM('Table'[Value])>20,"#FF0000","#00FF00")
Apply this measure to the Card visual:
And it shows:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
You can set Card visual->Format->Data Label->conditional formatting.
I create a simple sample to show.
Create a color measure to check:
Color = IF(SUM('Table'[Value])>20,"#FF0000","#00FF00")
Apply this measure to the Card visual:
And it shows:
Hope this helps.
Best Regards,
Giotto Zhi
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 |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |