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

In this YouTube video, we will review another use case of calculation groups in Power BI. This video will look at multiple solutions on how to hide columns in a matrix visual.

We'll explore practical solutions utilizing calculation groups and shed light on the significance of setting precedence effectively.

This tutorial provides a business-friendly walkthrough, offering practical insights to enhance your reporting skills and empower you to tailor your matrix visuals for more impactful data analysis. Don't miss out on this opportunity to refine your Power BI proficiency and elevate your reporting game! 📊

00:00 Intro
00:22 Problem Statement
02:15 Old way to solve it
03:20 Solution 1 - Calculation Groups
06:05 Solution 2 - Calculation Groups
07:30 Why precedence is important?
10:40 Final thoughts

#powerbideveloper #businessintelligence #bi #perytus #decipheryourdata #powerbipro #powerbideveloper #dax #fieldparameters #calculationgroups #learnpowerbi #howtopowerbi #powerbitraining #powerbiforbeginners #dataanalysis #microsoftpowerbi #microsoftpowerbidataanalysis #visualinteraction #visualizaton #calculationgroups #powerbicalculationgroups #matrixvisual #matrixvisualpowerbi #fieldparameters

[_siddhesh_pednekar]

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

[KMF]

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.

[zxccxz]

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

[sumeshkumar]

👍 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.

[zenny]

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

[skillstopaythebills]

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?