Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
10 years ago

changing legends on pie chart

HI i have two columns connected each other for example  category-> product for each product a sum sales. i have slicer with the categories.   i have a pie chart and i want it to act like this:...
Need Help
MP_123's avatar
MP_123
Microsoft Employee
10 years ago

i succeded to create new measure with the values i want... the problem is that measure cannot defined as legend :/ 

BrentA's avatar
BrentA
Advocate II
10 years ago

Thats a tough one. You want a dynamic legend which changes depending on a filter selection. Im not sure this is supported or any workaround exists that I can think of...

  • MP_123's avatar
    MP_123
    Microsoft Employee
    10 years ago

    yes.. it's hard BrentA

     

     

    anyone?

     

    thanks!!

    • v-caliao-msft's avatar
      v-caliao-msft
      Microsoft Employee
      10 years ago

      Hi Mp_123,

       

      Currently, all the legend members will display on your pie chart. If you select few items on your pie chart, other items will gray out on your chart legend.

       

      In your scenario, you can turn legend off, and use a Multi-row card visual instead. You can control the visual size to display any numbers of items you want. And if you select few items on your pie chart, other items will disappear on your Multi-row card visual.

      Regards,

      Charlie Liao