topic Re: Dynamic legend based on measure in DAX Commands and Tips

Dynamic legend based on measure

Anonymous — Tue, 04 Oct 2022 19:51:13 GMT

Hello everyone!

I need some help here:

I have a measure and I need create dynamic ranges to use as legend based on this measure.

For example:

But in other context I can apply a filter that modify the measure value to the Units and the range legend need to assume other category

The problem is I can't create other measure to use as a legend, this is not possible in visuals, so I need to find other way to do this.

jgeddes — Tue, 04 Oct 2022 20:48:29 GMT

You might want to use a calculated column for your Range Legend.
The calculated column can be used in slicers and visuals.

Anonymous — Wed, 05 Oct 2022 12:34:46 GMT

jgeddes,

I tried this way, but using a calculated column, when the measure value change, the legend will remain the same.