show the Percentage of parent row total in Power BI matrix

[pang22]

Hi,

I can make Percentage of parent row total in Excel.

How to show the Percentage of parent row total in Power BI matrix?

Power BI:

Excel:

Excel (Percentage of parent row total):

[v-xingshen-msft]

Hi @pang22 ,
If you can't show the percentage of the parent hierarchy in the software, we can do it by measure, here is the related resolved document I found for you hope it will help you!

Solved: Percentage of parent column total (parent row tota... - Microsoft Fabric Community
Solved: Show percentage of parent total - Matrix Visual - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[remonseha]

Right click on the values field and select show values as percent of row total

[ann_2024]

Hi @pang22 ,

You can achieve it using matrix visual (refer screenshot)

You also need to enable the row subtotal in visualization pane.  

This step would help you to get % of parent row total

[miTutorials]

Right click on the values field and play around with your requirement. From the picture that you have posted you might want to choose Percentage of Column Total.

[pang22]

@miTutorials 

But there is no Percentage of parent row total. How to find it? Thanks.

[Thejeswar]

@pang22 ,

If you are not getting this option, you can use the below measure for this purpose

Percent_of_grand_total = 
VAR NUM = CALCULATE(SUM(A[QUANTITY]))
VAR DEN = CALCULATE(SUM(A[QUANTITY]), REMOVEFILTERS(A))
RETURN
DIVIDE(NUM, DEN)

 Post adding this measure to the table, add the totals in the properties as shown below

Regards,

[pang22]

@Thejeswar 

I right click in PowerBI and only have these options. No % of parent row total

[Thejeswar]

@pang22 ,

If you see the screenshot @miTutorials shared, it shows the selection to Percent of Column total. In your screenshot also, you are having that option. You can use that.

If that is not working, you can use the DAX measure I have shared above. Pasting the same here again.

Percent_of_grand_total = 
VAR NUM = CALCULATE(SUM(A[QUANTITY]))
VAR DEN = CALCULATE(SUM(A[QUANTITY]), REMOVEFILTERS(A))
RETURN
DIVIDE(NUM, DEN)

 Post adding this measure to the table, add the totals in the properties as shown below