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!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!