Forum Discussion
Sub Total within a total graph
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
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.
3 Replies
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Hi,
Something like the below that was done in excel
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.
