Calculated Row at bottom of a matrix or table Visualization

[Prathyush]

Dear All, I am looking for a data visualization as below, In below data, sales is from One table ,budget is from another table and i need to bring the budget total lafter  total sales row, then the difference also.  Which visualization will help me to get this tabular data.?

Date	Sales
01.04.2017	87,155.15
02.04.2017	75,671.05
03.04.2017	53,656.58
04.04.2017	95,583.53
05.04.2017	81,566.91
06.04.2017	55,232.89
07.04.2017	19,664.03
08.04.2017	85,603.81
09.04.2017	92,895.74
10.04.2017	49,260.52
11.04.2017	110,258.68
12.04.2017	119,984.92
13.04.2017	74,187.71
14.04.2017
15.04.2017	80,569.64
16.04.2017	89,012.01
Grand Total	1,170,303.16
Total Budget	2,500,000.00
Difference	-1,329,696.841

Regards

Prathyush

[Greg_Deckler]

There may be a custom visual out there for this but I do not believe any native visuals will allow you to add random rows to the bottom. You could "fake" it by using multiple table visuals or card visuals combined with text visuals.

[Prathyush]

Dear Smoupre,

Is it possible for you to suggest me a custom Visual?

regards

Prathyush

[v-huizhn-msft]

Hi @Prathyush,

After research, there is no an appropriate customer visual. You can create a measure, and display it in muti-row card.

1. Create total sale using Sale_table.

Total_sale=SUM(Sale_table[Sale])

2. Create total budget using Sale_table.

Total_budget=SUM(Sale_table[Sale]) 

 
3. Create difference based on the measures above.

Difference=Total_sale-Total_budget

Then add the three measure in muti-row-card. Please see the following screenshot.



Best Regards,
Angelia