Making titles in data table into legends/lables in visuals

[wToTheH]

I have a data table that I am adding columns to each week.  Each column of this table shows stock for a given date.  The date is the column header.

I want to create a bar chart that shows the amount of stock against each date.  Ideally, I need to put the date at the bottom of the barchart, corresponding the the line for that date, rather than just 'Date' as it is in the picture.

As the data table headers are the dates, it makes sense that I should be able to add them below, but I can't find any toggle for this that gives me what I need!  Can anyone help?

[v-echaithra]

Hi @wToTheH ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[v-echaithra]

Hi @wToTheH ,

I hope the information provided is helpful. If further assistance is still required, we are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[rohit1991]

Hi @wToTheH 

Could you please try below Steps:

1. Sample Data Set used to solve problem

2. In Power Query, select all the non-date columns (like CCS, Abbreviated Size, etc.).

• Right-click >> Unpivot Other Columns.

• This will convert your date headers (19/08/2025, 15/09/2025, 30/09/2025, etc.) into rows under a new column called Attribute.

• The stock numbers will go under a column called Value.

3. Changed Table.Click on Close and Apply.

4. Outcome:

[wToTheH]

Hi, this works really well for the data already in the power BI model.  Next week, I will have to add another column with that week's stock, and again the week after and so on.  Is it possible to do this easily?

[rohit1991]

Hi @wToTheH 

If you use Unpivot Other Columns in Power Query, any new weekly stock column you add will automatically appear as rows under the Date field after refresh no need to redo the steps.

[wToTheH]

I wonder if I have missed a step? when I try to add a fictional column for 15th October, it does not appear.  Have you seen this before?

[v-echaithra · Accepted solution]

Hi @wToTheH ,

First, verify that the new date column (15th October) has actually been added to the source table. If you’ve added the column to the source but it doesn’t appear in Power BI, make sure to refresh the data in Power Query. Sometimes, a filter might have been applied during your previous steps in Power Query that’s preventing the new column from showing up. If filters exist, modify or remove them to include the 15th October column. Power BI may not recognize the new column if there’s a mismatch in data types. Ensure that the new date (15th October) is in the correct date format. If you’re unpivoting columns, ensure that you correctly select all date columns during the unpivot process, including the one for 15th October. After performing these actions, make sure to click "Close & Apply" in Power Query to apply the changes to the Power BI model. If you don’t apply the changes, Power BI won’t update the dataset.

After applying the changes, go to the Data View in Power BI and check the dataset directly. Look for the 15th October date in the Attribute column. This is where you can confirm if it’s available before visualizing it.

Hope this helps.

[wToTheH]

Thanks, that's got it!

[danextian]

Hi @wToTheH 

Your data isn’t structured correctly for reporting. Dates should be listed in a single column, with another column holding their corresponding values. In the Query Editor, select the CCS and Abbreviated Size columns, then right-click and choose Unpivot Other Columns.  Change the data type of the date column to date after unpivoting. Without this step, you’ll need to manually add each new column to your visual instead of having it update automatically. 

[wToTheH]

Hi, this works really well for the data already in the power BI model.  Next week, I will have to add another column with that week's stock, and again the week after and so on.  Is it possible to do this easily?

[srlabhe]

 Yes it shoudl work as explained by danextian