Sub Total within a total graph

[UK_User123456]

Hi All,

Just wondering if there was a way to show sub total out of a grand total in a donut chart?

as an example, I was trying to do a donut chart that shows my grand total of customers and then the sub total of customers that we kept i.e.

grand total = 5000

Sub total = 2500

The totals are from the same fields within a table, so not sure if this is possible

[v-jayw-msft · Accepted solution]

Hi @UK_User123456 ,

You can create a calculated table incloud sub-total and grand-total.

Here's my sample data.

Raw table:

Calculated table:

Table 2 = UNION(DISTINCT(SELECTCOLUMNS('Table',"type","grand total","value",SUM('Table'[value]))),'Table')

 

Result would be shown as below:

You can create a measure like below and add it to visual level filter to filter out the specific type.

Measure = IF(SELECTEDVALUE('Table 2'[type])="grand total"||SELECTEDVALUE('Table 2'[type])=SELECTEDVALUE('Table'[type]),1,BLANK())

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

[UK_User123456]

Hi, 

Something like the below that was done in excel