Dynamic Column Labels in Power BI Based on Selected Date

[FBu_Gavin]

Hi all,

I’m trying to create dynamic column labels in Power BI based on a date selected by the user.

Scenario:
I have a dataset showing Stock on Hand (SOH) by date and product. In Power BI, I want to build a table where a slicer allows users to select a date. When a date is selected:

• The first column shows Current SOH for that date, and its label dynamically displays the selected date.

• The second column shows SOH for the previous day (selected date - 1), and its label updates accordingly.

  I can calculate the measures using DAX, but I haven’t found a way to make the column headers update dynamically based on the selected date.

  Example logic:

   

  SOH_SelectedDate = CALCULATE( SUM(Data[SOH]), Data[Date] = SELECTEDVALUE(DateTable[Date]) ) SOH_PreviousDate = CALCULATE( SUM(Data[SOH]), Data[Date] = SELECTEDVALUE(DateTable[Date]) - 1 )

  What I’ve tried:

  • Using SELECTEDVALUE() and FORMAT() for card visuals (works fine for titles, not for table headers).

  • Disconnected tables and parameters for date selection.

    Context:
    I previously used Qlik, which allows users to define both a measure and a label expression dynamically. I’m looking for a similar capability in Power BI.

    Any ideas or workarounds would be greatly appreciated!

    Thanks,
    Gavin