Thank You for posting your query onto the Forum.
To achieve this result firstly you’ll be required to turn off the “Word Wrap” option of the following menus -
- Column Headers
- Row Headers
Now, once you turn off the “Word Wrap” option of the following menus. Now, just hide the columns that you don’t want to showcase in your reports, in this case, it’s the “Variance” columns. To hide the particular column just move your cursor at the headers in between the two columns and the cursor will get converted into the “Double - Sided Arrow” and than just drag it to the left-side to hide it. And by this way I’ve hidden all the “Variance” columns in the matrix visual.
Now, to have the Sub-Totals for “Sales” and “Variance” at a columnar level like you want. Just go to the “Sub-Totals” section/menu and turn on the option of “Column Sub-Totals” and than follow the same process. That is, showcase only the columns that you want for sub-totals and hide the remaining of them.
And below is the screenshot provided of the end result -
I’m also attaching the working of the PBIX file for the reference so that you can have a close look at it.
Hoping you find this helpful and meets your requirements that you’ve been looking for.
Important Note: As of now, Power BI doesn’t have the option to hide all the columns at once. So this will have to be done one-by-one.
Thanks and Warm Regards,
PBIXMN - Harsh.pbix (15.9 MB)