How to create/add row total and grand totals as tooltips for 100% Stacked Bar Chart

[Anonymous]

Dear Forum friends,

I have created a 100% Stacked Bar Chart to show the number of children' exits from foster care for each month of FY2023. 

As shown in screenshot below,  the % of exits in the label are for each of 6 exit reasons. The values are all from a single measure called "M_CountExits". I would also like to include in the tooltips the row total of exits (regardess of exit reason), and the grant total of exits (regardless of month and exit reason). What is the best way to achieve this? How to construct the measures necessary for this? I have tried to use all / allexcept to construct the measures, but without success. Any advice is appreciated. 

Thanks.

Lijun 

[Uzi2019]

Hi @Anonymous 

You can change the chart type from 100% stack to Stack bar chart.

There is option of total label.

I hope this may resolved your issue!

[Ashish_Mathur]

Hi,

I am not sure how muchi can help but i'd like to try.  Share the download link of the PBI file.