conditional formatting bar chart not working

[kcreno]

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! 

[danextian · Accepted 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

[kcreno]

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.

[danextian]

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.

[DataNinja777]

Hi @kcreno ,

Please refer to the solution provided by @danextian in the link below:

https://community.fabric.microsoft.com/t5/Desktop/How-to-color-negative-number-in-red-in-stacked-bar...

Best regards,

[kcreno]

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.