Forum Discussion
Conditional Formatting a Line Chart in Power BI
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:
Pragati11 PaulP
While your bar chart solution is quite intuitive, I'm using first the traditional line chart solution
However I get a gap and want the lines to be joined on my actual dataset.
If this doesn't work I'll like to try the bar chart approach.
However what measure should i use in the bar chart in the value column, since conditional formatting requires me to have only 1 value.
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: