Forum Discussion

nagaraj's avatar
nagaraj
Post Patron
6 years ago
Solved

expand collapse for column matrix

Hi,

 

 We have a requirement to display the matrix with Column headers ( has drilldown Year -- Quarter -- Month).

 

 I am not seeing + / - buttons for column headers. 

 

 Is it possible ?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi nagaraj 

    Yes, you need a hierarchy to exist in the data to be able to expand/collapse in the way you want. 

    HTH

    Michele

6 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi nagaraj 

    not sure I understand completely what do you mean, but I know the only +/- option in built-in matrix visual that expands rows

    • nagaraj's avatar
      nagaraj
      Post Patron
      6 years ago

      I need to provide user an option to expand and collapse for columns.

       

      So searching +/- buttons as we have the option for Row Headers 

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi nagaraj ,

     

    I don't think so. The fields can be expanded only when there is a hierarchy in the data. The hierarchy between columns does not exist and only exists between rows.

    But you can try to drill on the columns.

     

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