Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

 

Dynamic_Header.PNG

 

 Kindly suggest as to how to achieve this.

 

Thanks in advance,

Ajay

1 REPLY 1
v-yuta-msft
Community Support
Community Support

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:

Capture.PNG 

 

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

1.PNG2.PNG 

 

The result is like this:

Capture.PNG 

 

Regards,

Jimmy Tao

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.