Display summary in Charts

[norivenkat]

Hi

In power bi below chart is monthly sale. How to display total summary of all along with each channel as shown belos

Thanks.

[Anonymous · Accepted solution]

Hi @norivenkat 

Thanks for the reply from lbendlin .

@norivenkat , if I understand correctly, are you trying to show total on the pie chart? The following testing is for your reference.

My sample:

1. Create a measure as follows.

Measure = SUM('Table'[Value])

2.  Put this measure into card visual and turn off the background color of the pie chart

Is this the result you expected? If I have misunderstood you, please provide some sample data so I can help you better. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

[norivenkat]

Hi

I do accept what you said. But what I want to show is the grand total. So that who ever looks at the report they can see yes this is total 5k or 10k and in chart the distribution by channel .

Thanks

[lbendlin · Accepted solution]

Use a separate card visual.

[Anonymous · Accepted solution]

Hi @norivenkat 

Thanks for the reply from lbendlin .

@norivenkat , if I understand correctly, are you trying to show total on the pie chart? The following testing is for your reference.

My sample:

1. Create a measure as follows.

Measure = SUM('Table'[Value])

2.  Put this measure into card visual and turn off the background color of the pie chart

Is this the result you expected? If I have misunderstood you, please provide some sample data so I can help you better. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

[lbendlin]

Please consider a different chart type.  Pie charts should only be used if the data is truly representing 100% of the topic.