Matrixansicht in Power BI

[vkginoya]

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!

[vkginoya]

Hi, thank you for the response. I tried to achieve this with help of UNION function but I see a blank matrix when display value is plotted on Values field. Could someone please assist here to achieve this visualisation with help of UNION function? 
Community help will be really appreciated here and thank you in advance!

[Tutu_in_YYC]

I dont see how it is possible, but i may be missing something here. Can you provide the pbix of what you have done and what the result was?

[vkginoya]

pbix is not supported here, how can i share my dashboard here to get help?
Thank you!

[Tutu_in_YYC]

Do you have this feature on your end? I think you can attach a pbix, if it is below 47mb.

[vkginoya]

I dont see such option, have a look at snip. I tried to drag and drop the dashboard but its not working. Do you know, why I am not seeing this option?

[Tutu_in_YYC]

Thats odd, but i will not be suprised if that function is only available for "verified" users to prevent spams. Anyway, try using dropbox or google drive if you have any.

Alternative, you can provide as many screenshots as possible so we can get a better idea of what you are doing, the current results that you getting and  what you want to get as a result.

[Anonymous]

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:

Microsoft Idea

Microsoft Idea

Microsoft Idea

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.

[Tutu_in_YYC]

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]

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