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!

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

conditional formatting bar chart not working

5 Replies

DataNinja777
Super User
2 years ago
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-chart/m-p/3774611#M1223250

Best regards,
- kcreno
  New Member
  2 years ago
  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.
danextian
Super User
2 years ago
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
  New Member
  2 years ago
  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
    Super User
    2 years ago
    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.

Forum Discussion

conditional formatting bar chart not working

5 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting