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
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
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!

Jan NL Carousel

Fabric Community Update - January 2025

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