Dynamic Column headers using Field Parameters

[Emmy66]

Hi, 

Currently, I have to edit these column headers each year, for 2025 below, the 1st row is what it looks like and should stay same until the end of the year when it now switches to the 2nd row in 2026. I have tried using Field Parmaeters but my challenge is that I'm unable to make the column header stay same thru out the quarter till the end of the year.

I would be grateful if anyone can help on this please.

Thanks.

[v-nmadadi-msft]

Hi @Emmy66 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @Emmy66 ,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @Emmy66 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[Emmy66]

@AnilKapkoti thanks for your prompt response.
The below table is dependent on the parameters I created which populates the table based on user selection which is defaulted to Q1 of each year e.g. Q1 FY25 and based on this, all other data in the table is populated as shown below.

(Q4 FY24)

(Q1 FY25)

(Q2 FY25)

(Q3 FY25)

(Q4 FY25)

My challenge is that I have to rename this table headers each time we start a new year by going to the measure in the Visualisation Pane and right-clicking > Rename for this visual. I have to do this for 60 pages of my report. If I can find a well to dynamically change this based on the user selection parameter, that will reduce the time spent on maintaining the report.

[v-nmadadi-msft]

Hi @Emmy66  ,
Thanks for reaching out to the Microsoft fabric community forum.

Field Parameters are too dynamic for your use case. A disconnected table with SWITCH measures gives you year-stable headers that you only update once annually, not every quarter.


1) Create a custom “Header Table” – a simple disconnected table with the values you want to show as headers for the year (e.g. Q1 2025, Q2 2025, Q3 2025, Q4 2025).

HeaderTable =
DATATABLE(
    "Header", STRING,
    {
        {"Q1 2025"},
        {"Q2 2025"},
        {"Q3 2025"},
        {"Q4 2025"}
    }
)

2) Use SWITCH logic to tie measures to these headers.

Sales by Header =
SWITCH(
    SELECTEDVALUE(HeaderTable[Header]),
    "Q1 2025", [Sales Q1 2025],
    "Q2 2025", [Sales Q2 2025],
    "Q3 2025", [Sales Q3 2025],
    "Q4 2025", [Sales Q4 2025]
)

This way, the column headers will remain as “Q1 2025, Q2 2025…” until you replace the HeaderTable values at the end of the year.

3) Control Header Roll-over: When moving into 2026, you just update the HeaderTable to show “Q1 2026, Q2 2026…” and your visuals will immediately align without having to edit the visual headers manually.

This is the expected output

Attaching the sample .pbix for reference.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[Emmy66]

@v-nmadadi-msft, thanks for the proposed solution. Very much appreciated. I've tried implementing that and it worked for Matrix but not for Table. Any idea how this can be achieved using a table please.

[v-nmadadi-msft · Accepted solution]

Hi @Emmy66 ,
Glad to hear it worked in the Matrix visual. Unfortunately, Tables in Power BI don’t allow you to ‘replace’ or ‘override’ the column headers the way a Matrix does. A Table always shows the actual field names from your model. That’s why the disconnected Header Table + SWITCH logic works in Matrix (because the headers come from the Header Table), but not in Table.


Thank you

[Shahid12523]

Use a Header Mapping Table with year-based columns (e.g., 2025 vs. 2026).
Create DAX measures that pull the correct header using YEAR(TODAY()).
Use those measures in your matrix visual so headers auto-switch at year-end—no manual edits needed.

[AnilKapkoti]

Can you please elaborate this a bit more. It seems like your screenshot is a excel screen shot.