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 ...
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.

     

     

RayWu's avatar
RayWu
Icon for Memorable Member rankMemorable 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...