Forum Discussion
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.
At the end of the matrix I am trying to add in some additional information, where we are taking the totals of the aforementioned and multiplying them by a PD and an LGD to get a reserve amount.
I was able to create a couple of measures that allow me to only show these PDs, LGDs and Reserves after the totals column and not in the value rows but they are still showing as blank column headers in the body of the matrix.
I am also having an issue with the 100% at the end of the PD/LGD totals as it is not necessary and should be blank.
I would like to get rid of/hide the highlighted sections in the screen shot below.
Failed solution attempts from youtube/internet: chaning color of text to match background color, removing totals in formatting pane, right click - exclude (ends up excluding the entire column not just the yellow), resizing columns.
I dont understand why its not as easy as right click - hide. Seems overly complicated for something so simple.
Thank you all for your time!
- Anonymous2 years ago
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.
2 Replies
- AnonymousNot applicable
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.
- NameTakenFrequent Visitor
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