How To Hide Columns In Matrix Visual - Calculation Groups and Power BI

really cool...how can you sort by calc item in the column??

Hi and thanks for the video. I have used the SELECTEDVALUE method which works to hide the values but the column header still shows. Any idea what I may be doing wrong?

Very useful information and explained simply as per usual! Extending calc groups further then, if you have an FY Slicer, is it possible to use the value selected as part of a calculation group item heading in a Matrix visual? Such as FYTD HIRES (<Selected FY>), eg. FYTD HIRES (FY24). There doesn't appear to be an 'fx' option on 'Text' to do that. Just wondering if there was a workaround trick? Thanks.

Hi I am trying to get only the variance for the latest two periods selected , how to do it without using calculation group

Thank you so much for the fantastic content, sir. I truly appreciate it and love it.

Thank you 😊😊

This works great, thankyou!

👍 good method!
Ques: instead of time period if Im using category/subcategory from data then can I directly use that column and only use the Cal group measure as done for order count?

Note: there can be 10+ categories.