Skip to main content

Power BI

Needs Votes

Dynamic table/matix column headers based on variable or dax expression

Vote (14) Share
Brendt Wooi's profile image

Brendt Wooi on 28 Oct 2020 09:23:12

It would be great if the column headers in tables or matrix could be dynamically changed with a variable or expression. coming from Qlikview environment which has this functionality i am surprised that Power BI does not support this. building sales figure dashboards where the column header needs to reflect what the column is currently displaying is crucial to show the end user what they are viewing.

for example displaying sales by year vs a previous year or any selected years from a slicer, or changing the column from displaying sales figures to displaying cost in the same column. the column contents can easily be switched but the column header remains static

It would be great if this would be incorporated into Power BI desktop on Prem.

Comments (2)
Brendt Wooi's profile image Profile Picture

Brendt Wooi on 16 Nov 2020 07:36:33

RE: Dynamic table/matix column headers based on variable or dax expression

It really is very frustrating that this seemingly simple function does not exist in Power BI.

Brendt Wooi's profile image Profile Picture

Katharine Cooney on 04 Nov 2020 17:32:22

RE: Dynamic table/matix column headers based on variable or dax expression

My client just wants the title to reflect the group of the data - sounds so simple - so difficult to do in BI