Forum Discussion

Prathyush's avatar
Prathyush
Frequent Visitor
9 years ago

Calculated Row at bottom of a matrix or table Visualization

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

DateSales
01.04.201787,155.15
02.04.201775,671.05
03.04.201753,656.58
04.04.201795,583.53
05.04.201781,566.91
06.04.201755,232.89
07.04.201719,664.03
08.04.201785,603.81
09.04.201792,895.74
10.04.201749,260.52
11.04.2017110,258.68
12.04.2017119,984.92
13.04.201774,187.71
14.04.2017 
15.04.201780,569.64
16.04.201789,012.01
Grand Total1,170,303.16
Total Budget2,500,000.00
Difference-1,329,696.841

 

Regards

Prathyush

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    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's avatar
      Prathyush
      Frequent Visitor
      9 years ago

      Dear Smoupre,

       

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

       

      regards

      Prathyush

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        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