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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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