Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic header names in Table visual

Hi there,

 

I am working on a report wherein I would like to have dynamic header names on my Table visual. Pls see screenshot below for a sample report(prepared in excel). I need to display the month name for current and previous 2 months in the header.

 

The first table (Sales data as on 31-Dec-2018) gives the Sales for December, November & October and the second table (Sales data as on 30-Nov-2018) gives the Sales for November, October and September.

 

 

 Kindly suggest as to how to achieve this.

 

Thanks in advance,

Ajay

Need Help

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi Ajay123,

     

    So your requirement is to change the table column dynamically, right? I'm afraid dynamic table couldn't be achieved, however, as a workaround, you may follow steps below:

     

    Click query editor-> click on columns Dec-18, Nov-18 and Oct-18 and click transform-> Unpivot Columns, the result is like below:

     

     

    Then drag the three columns to Matrix visual like below and set visual level filter on column Date:

     

     

    The result is like this:

     

     

    Regards,

    Jimmy Tao