Forum Discussion

norivenkat's avatar
norivenkat
New Member
2 years ago
Solved

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.  
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
    lbendlin
    2 years ago

    Use a separate card visual.

norivenkat's avatar
norivenkat
New Member
2 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Use a separate card visual.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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