Plan vs Actual with Column Series

[curiouspbix0]

Hello Visual Experts,

What visual and how could I represent plan bar vs actual stacked bar driven by column series on the same chart ?

[Anonymous · Accepted solution]

HI @curiouspbix0,

You can create a parameter table with 'actual' and 'plan' category and use on your chart legends field.
then you can write a measure with a switch function to change different results based on the current legend.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Regards,

Xiaoxin Sheng

[amitchandak]

@curiouspbix0 , Try to add two measures (actual and plan)  without legend in the stacked visual and check

or check this visual

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview

https://www.defteam.com/stacked-clustered-bar-chart/

[curiouspbix0]

Either did not work