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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Rosaksor
New Member

Percent of Grand Total" Option Disappeared

Hi,
Not long ago, while creating a report, I was able to use the "% of Grand Total" option. Now, when I try to use this feature, it doesn’t appear in the "Summarization" section – there’s no possibility to edit or change it.
Currently, only options like Sum, Average, Minimum, Maximum, etc., are displayed.
I know I can create a DAX measure, but this feature was very useful for me. Is it possible to enable it somewhere in the settings?

Thank you in advance for your help!

1 ACCEPTED SOLUTION
audreygerred
Super User
Super User

Hi! I think this is depending on whether or not you are using the new pane manager. Assuming you are and "show value as" is missing, you can use visual calculations. For example... I will start with Sales by Category:

audreygerred_0-1737666282604.png

To show this as percent of total, right click on the visual and select New Visual Calculation

audreygerred_1-1737666356286.png

Next, select percent of grand total:

audreygerred_2-1737666396301.png

You will now see this:

audreygerred_3-1737666423079.png

I then replaced [Field] with [Sales] and Axis with Rows:

audreygerred_4-1737666486315.png

Click the green checkmark.

Now you will have this:

audreygerred_5-1737666528878.png

But, lame - it doesn't automatically do % for you, so now, go to the Properties tab of the Format pane and expand Data format, then select your field from Apply settings to, leave data type as decimal, but change format to percentage and decide how many decimal places you want:

audreygerred_6-1737666671345.png

Now, you will have this:

audreygerred_7-1737666700978.png

Hope this helps!

Here is an article from msft with more details: Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
Rosaksor
New Member

Thank you very much for your help. Fortunately, I managed to resolve the issue before your post. Nevertheless, your input might be very helpful for other users. Earlier, I changed the settings to a"moore professional setup" and the 'Show As' option changed its position."

 

 

You are very welcome!! Glad you got it figured out! I was just clicking around more and found the easy way with Show value as too. So, if anyone else is looking for it and when you click on your measure or field and you see this when before you used to see "Show value as"

audreygerred_0-1737668528233.png

 

Instead, right click on your measure in the build pane, then the Show value as is available: 

audreygerred_1-1737668598128.png

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





audreygerred
Super User
Super User

Hi! I think this is depending on whether or not you are using the new pane manager. Assuming you are and "show value as" is missing, you can use visual calculations. For example... I will start with Sales by Category:

audreygerred_0-1737666282604.png

To show this as percent of total, right click on the visual and select New Visual Calculation

audreygerred_1-1737666356286.png

Next, select percent of grand total:

audreygerred_2-1737666396301.png

You will now see this:

audreygerred_3-1737666423079.png

I then replaced [Field] with [Sales] and Axis with Rows:

audreygerred_4-1737666486315.png

Click the green checkmark.

Now you will have this:

audreygerred_5-1737666528878.png

But, lame - it doesn't automatically do % for you, so now, go to the Properties tab of the Format pane and expand Data format, then select your field from Apply settings to, leave data type as decimal, but change format to percentage and decide how many decimal places you want:

audreygerred_6-1737666671345.png

Now, you will have this:

audreygerred_7-1737666700978.png

Hope this helps!

Here is an article from msft with more details: Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.