Add Grand Total (derive from calculated measure) to Bar Chart

[Chirag4370]

how can I add a bar of the total with values shown in given table (in snapshot)? I want the bar as total in a Bar chart like other units. %m_delta is the measure calculated base on the difference between percentage of the current month and the previous month. Similarly, %y_delta is the difference between current month and the last 11 months. all calculation and data set are given in PBIX file. Click on the link to avail PBXI file. https://drive.google.com/file/d/1S0A_enbjS891EVwNRPWT2pPBJiBornbY/view?usp=sharing 

Any help would be appreciated.

@MFelix @amitchandak @Greg_Deckler 

[v-rzhou-msft]

Hi @Chirag4370 ,

Do you want to get sum of percentage in Total? If not, please tell me what kind of result you are looking for.

Please show me a screenshot with the result you want. I am still confused about your requirement.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chirag4370]

Here, in the snapshot we have 3 pairs of bars for units a, b and c. I want the 4th pair of bars for the total and its values ​​should be equal to the values ​​shown in the matrix/table total (for selected month valuea are 1.25% and 0.25%) in the snapshot. (not the sum of actual percentages). The values ​​shown in the matrix are calculated using two different measures, namely %m_delta and %y_delta. in which %m_delta is the percentage difference between the current month and the previous month. And %m_delta is the percentage difference between the current month and the previous 11 months percentage. All calculation and data are given in PBIX file provided via Google drive link.