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.

     

     

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity 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.