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 d...
Need Help
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