Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
Solved! Go to Solution.
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:
To show this as percent of total, right click on the visual and select New Visual Calculation
Next, select percent of grand total:
You will now see this:
I then replaced [Field] with [Sales] and Axis with Rows:
Click the green checkmark.
Now you will have this:
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:
Now, you will have this:
Hope this helps!
Here is an article from msft with more details: Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
Proud to be a Super User! | |
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"
Instead, right click on your measure in the build pane, then the Show value as is available:
Proud to be a 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:
To show this as percent of total, right click on the visual and select New Visual Calculation
Next, select percent of grand total:
You will now see this:
I then replaced [Field] with [Sales] and Axis with Rows:
Click the green checkmark.
Now you will have this:
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:
Now, you will have this:
Hope this helps!
Here is an article from msft with more details: Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
Proud to be a Super User! | |
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |