Skip to main content

Power BI

Needs Votes

Dynamic or Conditional Column Titles

Vote (17) Share
Jamie Dickey's profile image

Jamie Dickey on 21 May 2021 18:07:20

Situation: A conditional column holds values for shipment departures and arrivals.

The report displays the supporting dimensions with the proper departure or arrival time based on a column of "type"

The column title is static. In order to keep from developing 2 reports one for departures and one for arrivals, the need is to be able to develop one report where the column title can change based on the users selection of departure or arrivals or the drill through on departures or arrivals.

This will greatly cut down on maintenance and oversight.

Comments (2)
Jamie Dickey's profile image Profile Picture

Joseph Pelky on 27 Mar 2024 15:59:06

RE: Dynamic or Conditional Column Titles

Any idea when this will be coming, really adds power to the table and dax queries?

Jamie Dickey's profile image Profile Picture

John Yip on 07 Oct 2022 01:44:19

RE: Dynamic or Conditional Column Titles

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.