Forum Discussion
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 series (not categorical) Columns->Series->Color->FX is no longer available. Only colors for each series are possible.
An obvious use case would be the above GREEN/RED for $0, but a series for each STORE sales (say), that may have different shades of GREEN/RED, representing respective PnL.
Seems like this is "almost there", but not quite.... A BUG
4 Replies
Define measures to calculate the color for each series based on your condition (e.g., green if > $0, red if < $0).
Example:
StoreA_Color = IF([StoreA Sales] > 0, "#008000", "#FF0000")
StoreB_Color = IF([StoreB Sales] > 0, "#008000", "#FF0000")Use Conditional Formatting:
In the Data Colors section of the visual:
Select the series (e.g., Store A, Store B).
Assign each series a respective measure for color under Conditional Formatting.
This approach dynamically adjusts the colors for each series in the chart.Thanks - But the bug is Color (FX) for conditional colors is NOT available for individual series (for multiple series). For a single series, its available.
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!
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
