Forum Discussion

snowside's avatar
snowside
New Member
4 years ago
Solved

Circle Visual Total amount

Hi everyone

 

I have total 10362 values. Various companies have shares in these values. For example, company A have 10% of the total. Now i want to create one circle visual for every company withe the total amount and the shares of % to the total . How can i create it?

 

Thanks for any advise

Chris

I 

Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    4 years ago

    Hi snowside ,

     

    If you want to display these five visual at the same time, you should create measures for each company.

    If you just want to compare them, you can create a slicer:

    First, create a new table for slicer

    Then apply it to the slicer and change it to single select:

    Create a measure and apply it to the visual

    Measure  = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Company]=SELECTEDVALUE('For slicer'[Company]))

     

    Final output:

    Best Regards,

    Jianbo Li

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

     

     

7 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    4 years ago

    Hi snowside ,

     

    Based on your description, I have created a simple sample like this:

     

    You can create a measure like this :

    Company A = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Company]="A"))

     Then add it to the Donut Chart:

    Final output:

    Best Regards,

    Jianbo Li

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

    • snowside's avatar
      snowside
      New Member
      4 years ago

      Thank you. So i need a Measure for every single company?

  • RayWu's avatar
    RayWu
    Memorable Member
    4 years ago

    snowside Copy and paste several pie charts and individually apply a filter on each one. 

     

    Then go to edit interaction and make sure all pie charts aren't interfering with each other. So that the user can still interact with the pie chart and dynamically update the total.

     

    • snowside's avatar
      snowside
      New Member
      4 years ago

      Hi

       

      Thanks for the response. The filtering with company is clear. In every visual i have 10362 total values. and i want to show how much of percentage for example the 1108 are...

       

       

  • RayWu's avatar
    RayWu
    Memorable Member
    4 years ago

    snowside so you want something like this?

     

    you need to create a card and drag it into the middle of the pie chart. Should be able to get the percentage total from the card option. 

    Might need to create a measure % of the value.

     

    • snowside's avatar
      snowside
      New Member
      4 years ago

      I want to have 5 different visuals and on each visual the percentage of 1 category compare to the total amount of the the total...

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    4 years ago

    Hi snowside ,

     

    If you want to display these five visual at the same time, you should create measures for each company.

    If you just want to compare them, you can create a slicer:

    First, create a new table for slicer

    Then apply it to the slicer and change it to single select:

    Create a measure and apply it to the visual

    Measure  = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Company]=SELECTEDVALUE('For slicer'[Company]))

     

    Final output:

    Best Regards,

    Jianbo Li

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