Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft 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:

when no category selected, to show the legend -"all" and the value will be the whole sales

when categroy is selected, to show the category's products legend/

 

now, when no category is selected the pie shows billion of products legends

 

do you have an idea? hope i was clear

thanks!

4 Replies

  • MP_123's avatar
    MP_123
    Icon for Microsoft Employee rankMicrosoft Employee

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

    • BrentA's avatar
      BrentA
      Icon for Advocate II rankAdvocate II

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