Forum Discussion
klehar
Helper V
4 years agoConditional Formatting a Line Chart in Power BI
I'm not sure if this is possible in Power BI, but want to try workarounds My requirement: For my data given below, I want to color Actuals with a different color and my Non Actuals with a differ...
- 4 years ago
You can use two measures instead of conditional formatting: one measure for Actuals and the other for the Forecast values (this measure must include the actual values to avoid the blank space in the chart). so:
Actuals = SUM(Table [Actuals]
Forecast = SUM(Table [Forecast]) + [Actuals]Place both measures in the values bucket and then format each measure to your liking:
klehar
Helper V
4 years ago@PaulDBrown tagging you since you have context