Forum Discussion
Solved
Matrix values issue
Hello everyone, I am trying to create a matrix that has both classifications and triggers where we are suming values (utilizing a case statement in my SSMS query). This part is working fine. ...
Hi NameTaken
The PowerBI matrix is designed to be just that, and you can refer to the replies to this post to achieve the effect you want:
Solved: Remove/hide column on Matrix table - Microsoft Fabric Community
Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric CommunityBest Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous !!
This worked well to hide those columns. Nice simple approach.
For anyone wondering about the yellow highlighted totals at the bottom, I changed my PD and LGD measures to a bit with the guidance of the below:
IF(
ISINSCOPE(F_AMOUNTS[Heading]) || ISINSCOPE(F_AMOUNTS[PARTS]),
SUM(F_AMOUNTS[Amount per unit]),
BLANK()
)
which I got from Solved: remove total of one column - Microsoft Fabric Community