Dynamic header names in Table visual

[Anonymous]

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

[v-yuta-msft]

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