is there a way to have a pick list of which legend measure shows?

[Anonymous]

i have a list of 5 measures i want to show in the Legend of my charts. as legend can have only 1 then is there a way to make a dropdown or radio list of choises to choose which one to show? kind of like a slicer single select for the legend part.

[v-shex-msft]

Hi @Anonymous ,

Nope, measure not able to use on legend/axis fields. (axis and legend fields, they require static value field to expand and summary values)

AFAIK, measure is a calculated expression, it need to calculate based on category or other group fields to split calculate range.

If no group fields existed, measure will calculate on whole table and return single value. 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

i did find some examples of using buttons + bookmarks to show/hide my 5 different visuals.