cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshcorti11
Helper III
Helper III

Add a total row to "Show as a Table" feature for visual

Hi Everyone,

 

I am attempting to show a total row in the table that is generated by right-clicking on the visual and then clicking "show as a table". Add Total Row.PNG

 

Is this possible in power bi?

 

Thank you

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @joshcorti11

 

you can't add a total row. Show data, shows the data inside the chart and as there is no total on the axis, it is not shown.

 

Even if a custom visual like the Zebra BI Charts visual, that allows creating a total column (but only for the column chart and not for the line chart) inside the chart, this Total is not added to the data forming the chart:

image.png

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
TomMartens
Super User
Super User

Hey @joshcorti11

 

you can't add a total row. Show data, shows the data inside the chart and as there is no total on the axis, it is not shown.

 

Even if a custom visual like the Zebra BI Charts visual, that allows creating a total column (but only for the column chart and not for the line chart) inside the chart, this Total is not added to the data forming the chart:

image.png

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Portrek
Resolver III
Resolver III

Hi joshcorti11

 

Unfortunately, this is not possible.

 

 

It shows you exactly what's on your chart; as your initial graph does not have the total, the table will also not show and in the viewing condition, unfortunately, we do not have the possibility to adjust the settings.

 

 

Best regards.

themistoklis
Super User
Super User

@joshcorti11 

 

I dont think you can add total row because the graph itself doesnt have a total attribute on x-axis

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.