Forum Discussion

dreyz64's avatar
dreyz64
Icon for Helper III rankHelper III
6 years ago

Dynamic Legend on a stacked column chart

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 param...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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's avatar
dreyz64
Icon for Helper III rankHelper III
6 years ago

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

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    dreyz64 no idea what you mean?

    • dreyz64's avatar
      dreyz64
      Icon for Helper III rankHelper III
      6 years ago

      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's avatar
        aalev
        Frequent Visitor
        4 years ago

        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!