Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
vkginoya
Regular Visitor

Matrixansicht in Power BI

Hallo,
ich brauche hilfe von diese tolle Power BI Community. Ich habe eine Matrix, in der ich möchte, dass die NomKapa-Spalte nur am Ende als Zusammenfassung und nicht für jede Modelle-Ebene sichtbar ist. Wie kann ich das erreichen, dass NomKapa gerade am Ende sichtbar ist, um es mit der Gesamtsumme des Bedarfswerts zu vergleichen (erreicht durch Summieren des Bedarfswerts auf jeder Modellebene)?
Vielen Dank im Voraus!

Hello,
I need help from this great Power BI community. I have a matrix where I want the NomKapa column to be visible only at the end as a summary and not for each model level. How can I make NomKapa visible just at the end to compare with the total demand value (achieved by summing the demand value at each model level)? I want to see matrix just with one NomKapa row at the end as summary.
Thank you in advance!
Power BI snip.pngAllegmein Ansicht .png

3 REPLIES 3
v-linyulu-msft
Community Support
Community Support

Thanks for the reply from Tutu_in_YYC , please allow me to provide another insight:

Hi, @vkginoya 
Thanks for reaching out to the Microsoft fabric community forum.

Currently, this feature is not supported in the matrix, but we have other alternatives. For example, you can create a table with a similar data structure, add a TOTAL field in the "PRN" or "Modelie" column, and then use the UNION() function to merge the data. This way, you can avoid using the total function of the visualization object. However, this requires a clear understanding of your data structure.

 

Here is a sample link that might help you:

Solved: Custom weekly(shows week range) and MTD columns in... - Microsoft Fabric Community
How to put the row and column subtotals in front o... - Microsoft Fabric Community
 

If you feel that performance needs improvement, you can submit an idea. Below is a screenshot and link of similar ideas:

vlinyulumsft_0-1737963532884.png

Microsoft Idea

vlinyulumsft_1-1737963532885.png

Microsoft Idea

vlinyulumsft_2-1737963571259.png

Microsoft Idea

vlinyulumsft_3-1737963571260.png

Microsoft Idea

You might consider accepting my answer as a solution, which will allow more people with similar ideas to see it. Just wait for users with the same needs to vote for your idea, helping you achieve it as soon as possible. Many features in our existing products are designed and upgraded based on customer feedback. As demand increases, this issue is likely to be resolved in the future.

 

Thank you for your understanding and support! If you have any other questions or need further assistance, please feel free to let me know.

 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Cool idea @vkginoya . Just note that the visual/total might require a data model refresh, ie cant updated by slicer on the fly

Tutu_in_YYC
Super User
Super User

Es sind viele Diskussionen daruber, aber alle ist ohne Loesung. Es geht einfach leider nicht. 😞 
Hier ist eins: https://community.fabric.microsoft.com/t5/Desktop/Hide-Measure-Row-in-Matrix/m-p/4320570

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.