Forum Discussion

FBu_Gavin's avatar
FBu_Gavin
Regular Visitor
9 months ago
Solved

Dynamic Label in the Table for Measure based on Selected Date

Hi everyone, I’ve simplified my question using the example below (see image).   I have a dataset showing Stock on Hand (SOH) by date and by product. In Power BI, I’d like to build a table (b...
Need Help
Tips and Tricks
  • danextian's avatar
    danextian
    9 months ago

    Hi FBu_Gavin 

     

    Power BI doesn't currently support dynamic column headers. You can either superimpose a card on the column headers or use a disconnected table containing a column that has all the possible combinations of  the date (formatted as text - dd/mm/yy, etc ) and your metric name and use a measure to determine which column values to return.

    Please see the attached sample pbix.

danextian's avatar
danextian
Super User
9 months ago

Hi FBu_Gavin 

 

Power BI doesn't currently support dynamic column headers. You can either superimpose a card on the column headers or use a disconnected table containing a column that has all the possible combinations of  the date (formatted as text - dd/mm/yy, etc ) and your metric name and use a measure to determine which column values to return.

Please see the attached sample pbix.

  • FBu_Gavin's avatar
    FBu_Gavin
    Regular Visitor
    9 months ago

    Thanks for the PBIX file! I’m currently using a card placed above the header, but your disconnected table approach gives me an alternative way to look at this issue.

    Cheers