Forum Discussion
Using a measure on the legend in a pie chart using directquery
I want the smaller pieces that are all less than 1% to be together in an "Other" slice. How can I do this?
I created a measure
Hi Anonymous ,
Yes, Legend only accepts entity columns as values.
Please new a calculated column like:
Legend = VAR _measure = CALCULATE([%_value],ALLEXCEPT('accounts','accounts'[name])) VAR _legend = IF(_measure>=0.01,'accounts'[name],"Others") RETURN _legendand then use it as legend's value.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
2 Replies
Hi Anonymous ,
Yes, Legend only accepts entity columns as values.
Please new a calculated column like:
Legend = VAR _measure = CALCULATE([%_value],ALLEXCEPT('accounts','accounts'[name])) VAR _legend = IF(_measure>=0.01,'accounts'[name],"Others") RETURN _legendand then use it as legend's value.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data