Forum Discussion
Variance Column for 2 Categories in the Same Measure
Hello, I have 3 measures that I want to show by version (actual and plan), so I use the version as a column and use those 3 measures as values. I need to add columns of variances between actual a...
amitchandak
Super User
Super Userttt , if you want to show variance only under the total , that is not possible. You have add it as a measure and it will repeat.
I have logged an idea for hybrid table, vote for that. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table
Thanks amitchandak! I couldn't click on a vote button for some reason.
Another way I can think of is to create 9 measures: reduction, in-quarter savings and annualized savings for actual, plan and variance but I also want double heading to make the data easy to digest. Do you know if it's possible to customize the header that way? Thank you so much!
