Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Can anyone please share your thoughts?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you.. its really helped

  • G05DVD's avatar
    G05DVD
    Frequent Visitor
    2 years ago

    Have struggled in the past and subsequently 'forgotten' how conditional formatting applies to the different visuals.

    Thank you for sharing your knowledge