How to get dynamic measure to update Legend on bar chart

[brittanyruffin]

Hi there,

I have created a dynamic measure that will give me results based on the slicer selected. The measure is working as suspected, but I would like the legend to also change based on what is selected on the slicer

Formula

DynamicMeasure =

    SWITCH(

        SELECTEDVALUE('vCorporateGandA'[LedgerType]),

        "Actual", [Current Month Actual],

        "Budget", [Current Month Budget],

        BLANK()

)

Chart:

The slicer is on "Budget" so I would like the yellow bar to show "Budget" instead of "DynamicMeasure"

[v-kongfanf-msft]

Hi @brittanyruffin ,

It is not possible to add a measure as bar chat legend, as measure actually returns a single value.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daniel29195]

@brittanyruffin 

try using field parameters .

https://www.youtube.com/watch?v=-nqEv2YXLsUe

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!

It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[brittanyruffin]

I will have 3 different charts that need to filter at the same time. I have 2 other charts for QTD and YTD. The field parameters didn't work for me