Adding value totals to my power bi visualization

[AudreyRene]

Hello,

I'm currently working on a project. I want to show the total entries in my visual (sum of the transaction). I dont want to add a new column into this visualization, i want to put the total on the right. I also want to add this value to my table. How can i do it ?

[kpost · Accepted solution]

After getting a better idea of what exactly you are trying to do, I have built a solution for what I would do in this situation.

Since you cannot include totals in the built-in "View as table" option, I would build both the line chart and the table, then use bookmarks to display one or the other.  This has the added benefit of allowing you to format the table however you prefer. 

Since you cannot include the total on the line graph, I would add a card visual 'in front of' the graph, and format the graph so that the line never goes 'behind' that card.  To achieve that, I made the maximum value of the Y axis a function equal to " MAX(Y Axis) * 1.15 " to make room for the "Total" card visual on the top right of the Line Graph.  You may have to modify this measure depending on your situation, but that's the general idea, assuming you want there to be a 'total' value displayed and you want it to be taller than the space the line graph has for the title of the line graph.  In the image you posted, your title font is pretty small, and the area you highlighted is on top of the area allocated for the line graph, so that's why I did this.

See attached .pbix file with the solution I would build for this situation.    To click the buttons in Power BI Desktop, hold down Ctrl before you click.

  

/// Mediocre Power BI Advice, but it's free ///

[kpost]

Edit:  This solution is not what AudreyRene was looking for.  See my other response for a workable solution.

For the line graph, there is no way to add a 'total' that sums all of the individual values.  You will have to add the 'Total' measure to another visual like a 'Card' and put it 'in front of' the line graph.

In the Table, any value that is formatted as whole numbers or decimals should automatically have a total value.

But to manually turn it on, follow these steps

>Format your Visual

->Totals

>turn Values "On"

Also, make sure that Summarization for that field is activated.

  

[AudreyRene]

Hello,

I think my explanation wasn't clear. I can see the total when i choose the visualization table 

The problem is when i choose another visualization, select the ... (right corner) and display as table. This table doesnt have any total. I want a total here.

[kpost]

ohhh, I see.  I don't believe that is possible.

I would just build the table as a visual, then use bookmarks and create a "View as Table" and "View as Line Graph" buttons

I will respond in a few moments with a .pbix file solving your problem the way I would do it.