Forum Discussion

MrMarshall's avatar
MrMarshall
Icon for Helper II rankHelper II
7 years ago

Filter and grouping problems on Pie chart

The goal is to concatinate Group 300 and 400 in the Pie chart to the left so it becomes one "999" group.   The data is simple in my example:  Group Value Year 100 100000 2018 10...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
7 years ago

MrMarshall

 

I created a measure for this. Please try this to see if this works. Thanks

 

Measure = if(SUM(Sheet16[value])>200000,SELECTEDVALUE(Sheet16[Group]),999)

  • MrMarshall's avatar
    MrMarshall
    Icon for Helper II rankHelper II
    7 years ago

    Thx for reply ryan_may!


    The problem is that I cannot use the the measure as a Legend in the Pie chart. 

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      7 years ago

      MrMarshall

       

      I see. Let's see if anyone else has the solution for this. Sorry I didn't resolve this.