Skip to main content

Power BI

Needs Votes

Have dynamic column headers in Paginated Report

Vote (4) Share
Sherry Shen's profile image

Sherry Shen on 28 Jun 2021 18:33:33

I have a company excel report that always pull last 3 weeks data and the header is changing based on each week. also the column header has 2 layers- sales -> week 23, 24,25 for example. 

I want to check if it's possible to have column headers also read in fx and what is the best way to format when there are multiple layers of column headers.