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.

xifeng_L's avatar
xifeng_L
Super User
9 months ago

Hi FBu_Gavin 

 

In PowerBI, column labels of matrices cannot dynamically return specified values.

 

But you can create an auxiliary table to store the values of all possible column labels, and then use the feature of auto hiding the corresponding column when the matrix column is empty to achieve the goal.

 

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~