Forum Discussion
Conditional Formatting for line and stacked column chart
Hi, How do i apply conditionaly formatting on Actual and forecast data on my chart? I am using line and stacked column chart and the values are Weekdate (Shared Axs), Actuals (Column Values) and...
Hi Anonymous ,
I created a sample pbix file(see attachment) for you base on your provided info, please check whether that is what you want.
1. Create a measure as below to judge the compare the size of Actual and Forecast
Measure = IF ( SUM ( 'Table'[Actual] ) > SUM ( 'Table'[Forecast] ), 1, 0 )2. Make conditional formatting on Columns field(not Lines field)
Best Regards
Hi Anonymous ,
I created a sample pbix file(see attachment) for you base on your provided info, please check whether that is what you want.
1. Create a measure as below to judge the compare the size of Actual and Forecast
Measure = IF ( SUM ( 'Table'[Actual] ) > SUM ( 'Table'[Forecast] ), 1, 0 )2. Make conditional formatting on Columns field(not Lines field)
Best Regards
Thank you.. its really helped