Unable to use measure for chart legend

[Dayna]

Hello,

I suspect it's the measure context that means this isn't working, but I'm trying to add this measure to a chart as the legend but every time I drag it to this field, it doesn't stick / apply.

Here's the measure:

Last Process = CALCULATE(MAX(Processes[Name]), FILTER(Processes, Processes[Ordering] = MAX(Processes[Ordering])))

It's a measure to get the latest process name based on the 'Ordering' field, so when added to a table of items, it shows the latest value within the process.

I think the measure might need to be different, perhaps a virtual table which the chart then uses, but I'm not sure.

Hopefully the above makes sense and this is something you can assist me with.

Many thanks,

Dayna

[v-binbinyu-msft · Accepted solution]

Hi @Dayna ,

It is not possible to add a measure as chart legend, as measure actually returns a single value. We can only add a column into legend section.

In your scenario, I would suggest you to add a card visual with your measure.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dayna]

Unfortunately that won't really meet my needs, as it's going against a pie chart - thanks anyway.