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

[Anonymous]

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". 

Is this possible in power bi?

Thank you

[TomMartens · Accepted solution]

Hey @Anonymous, 

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:

Regards,

Tom

[Portrek]

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]

@Anonymous 

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