Forum Discussion

tjd's avatar
tjd
Impactful Individual
9 years ago
Solved

Dynamic Legends Via Slicer

 

 

 I have viewed/read the article on Dynamically change the information within a visual via a slicer and have put the technique to good use.  However, I now need to have a clustered column chart in which I can dynamically change the legend from one category to another (see below).  The dynamic changing approach above does not work with legends as they do not accept measures, only column names.  Any ideas on how to use a slicer to dynamically change the Legend value?

Year Selected

 

 Quarter Selected

 

 

 

 

 

 

 

Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi tjd,

     

     

    So far, i dont think it's possible to achieve, but you could introduce for end-users drill-down with hierarchy buttons in the top left of charts.

     

5 Replies

  • tringuyenminh92's avatar
    tringuyenminh92
    Memorable Member
    9 years ago

    Hi tjd,

     

     

    So far, i dont think it's possible to achieve, but you could introduce for end-users drill-down with hierarchy buttons in the top left of charts.

     

    • tjd's avatar
      tjd
      Impactful Individual
      9 years ago

      Obviously not as elegant and intuitive as using slicers but workable.  Thanks.

      • danextian's avatar
        danextian
        Super User
        9 years ago
        I do think it's possible but can be a little complicated.