Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I cannot figure out what I'm doing wrong, I've watched several videos and I think I'm doing what they said.
It's very simply, if were down negative % I want red, if we're up and postive % I want green....
IDK why it isn't working.
Thanks!
Solved! Go to Solution.
Hi @kcreno ,
I forgot to hi reply earlier...
It seems that conditional formatting doesnt work on bars without categories. As a workaround, you can use a dummy column from a disconected dummy table and use that in the category axis
Hi @kcreno ,
I forgot to hi reply earlier...
It seems that conditional formatting doesnt work on bars without categories. As a workaround, you can use a dummy column from a disconected dummy table and use that in the category axis
Hi @danextian ,
Thanks so much for the solution. Unfortunalty, I am so new to Power BI I'm not even sure what a dummy column or table are. I'll have to continue to do some research.
Try this calculated table
Dummy =
ROW ( " ", " " )
Put the column " " in the category tile. That will return an error inititally but should be fine after adding the measure.
Hi @DataNinja777 , I tried that but it still didn't work? Is it because I'm working with percentages? I JUST started learning Powre BI and am not very familliar at all yet with DAX so I'm not sure what I'm doing wrong.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.