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 Forecast (Line values). Condition
if Actual> budget then green or else red. Please share your thoughts.
| WeekDate | Actual | Forecast |
| 02/16/2022 | 100 (Red line) | 110 (Green line) |
| 02/23/2022 | 200 (Green line) | 180 (Red lline) |
Regards,
Venkat
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
6 Replies
- amitchandak
Super User
Anonymous , if you are using legend, conditional formatting is not supported.
if can use clustered line visual then you can try
Try with both columns on the shared axis and concatenate label off, as I discussed in this video
Concatenate Label off : https://youtu.be/QgI0vIGIOOk
You will be able to use conditional formatting
amitchandak your solution is not working in my case..
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
