Dynamic Legend on a stacked column chart

[dreyz64]

Hello everyone,

I am trying to create a stacked column chart with a legend that can be changed via a slicer.

In Tableau it is very easy to do: I create a calculated field where I say "CASE parameterLegend when "SHOP", [Shop]

when "Market", [Market], etc..

Basically I tell my calculated field to take the values of the column shop if my parameter for my legend is equal to shop and so on.

I wanted to do the same thing in PBI: create a custom column where the values inside would take the values of the column i want to use as a legend.

However i cannot find a way to do this...
I have tried to illustrate what I want to do in the image below.
Thanks a lot for the help!

[parry2k]

@dreyz64 you are looking dynamic x-axis, check this video, hope it helps.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[dreyz64]

@parry2k  I am looking at a dynamic Legend (the colors), not the X axis which is fixed (or Y axis for that matter).

[parry2k]

@dreyz64 no idea what you mean?

[dreyz64]

@parry2k I have a stacked column chart.

In the stack column chart you can add a column to the 'Legend' section.

This will separate each bar in colors according to the values of the column put in legend.

Like so:

What I want to do now is that the field i put in the "legend' section to change based on a slicer selection.

[aalev]

Hi dreyz64, I have the same requirement, did you sort it out ?

I reformulate here:

How to dynamically change the way stack chart is stacked according to a slicer selection ?

I want to change the stacking dimension (called "Legend" in tack column visualization) according to a slicer selection. For instance: stack a sales fact table, "by state" or "by product category" or "by client type"...according to a slicer selection !

Thanks for your help!