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 ...
  • v-jianboli-msft's avatar
    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.