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 ...
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.
