Forum Discussion
Display summary in Charts
Hi
In power bi below chart is monthly sale. How to display total summary of all along with each channel as shown belos
Thanks.
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 XuUse a separate card visual.
4 Replies
- lbendlin
Super User
Please consider a different chart type. Pie charts should only be used if the data is truly representing 100% of the topic.
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
Use a separate card visual.
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
