Forum Discussion
Helper VDynamic Column headers using Field Parameters
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
Helper VAnilKapkoti 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.