Forum Discussion

philha's avatar
philha
Regular Visitor
1 year ago

Power BI Line and Column Clustered Chart - Column Color FX for multiple Col Series BUG

Hi, For single series COlumns, it is possible to use Columns->Color->FX to write logic to control the color of columns (GREEN if > $0, RED is < $0 for instance). However, if you add another COLUMN ...
Need Help
Uzi2019's avatar
Uzi2019
Community Champion
1 year ago

Hi philha 

 

Yes , You are right. once you add new column to legend filed you conditional formation FX option removed from color setting.

 

I would suggest you can use you column series in small multiple option you will be able to see the color formatting FX option under color setting.

 

 

But shift you category to small multiple you will see the Fx option enabled.

 

 

 

I hope I answered your question!

 

If you still think it is a bug you can create and raised your issue here. MS support will look into this if it gets more votes.

 

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

 

I hope I answered all your question!

 

 

philha's avatar
philha
Regular Visitor
1 year ago

Thanks for rapid support reply.

Unfortunately, not the type of Chart I interested in.  This is definitely a missing thing for sure..  Here is an example