Skip to main content

Power BI

New

Conditional or dynamic column header name in Table/Matrix

Vote (17) Share
Cedric Fodouop Kamologne's profile image

Cedric Fodouop Kamologne on 22 Mar 2022 17:27:44

Give ability to set dynamically header name of a field in a table. this can be see as a conditional formatting option for header title.

Comments (3)
Cedric Fodouop Kamologne's profile image Profile Picture

John Yip on 07 Oct 2022 01:41:07

RE: Conditional or dynamic column header name in Table/Matrix

Yes, this function is simple yet very useful.For example, if we choose a Year "2022" in a slicer, then the column name shall be something like "2022 Actual Sales".If 2021 is selected, then the column name shall be displayed as "2021 Actual Sales".This functionality is so simple but add a lot of clarity for users.

Cedric Fodouop Kamologne's profile image Profile Picture

Christopher Michael on 12 Aug 2022 07:59:15

RE: Conditional or dynamic column header name in Table/Matrix

It is utterly astounding that you can't do this in Power BI. An absolute basic of reporting is last 3 - 6 months stuff. I can abstract the data model, but labelling the table columns correctly is a must!!

Cedric Fodouop Kamologne's profile image Profile Picture

Adrienne Lyon on 14 Apr 2022 23:16:25

RE: Conditional or dynamic column header name in Table/Matrix

Dynamic headers would be ideal. My filters allow months and years to change. For example - If I'm looking at March 2022 vs March 2021 and change the comparison column measure filter to March 2019 (pre-covid) I need the column to show what month and year I'm reviewing.