Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Rename Date Column Header

Hello all,

 

I am working with a Table visualization. I have two different Years as columns, both by year and month. I want to rename the column headers for this data to avoid confusion.

 

I can rename the other columns but I don't seem to be able to rename the date fields. 

 

Any easy solution to this? Or should I create a new measure with each date and then rename that? 

 

Thanks!

Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    This is a wild guess on what you are trying to acheive. I'm presuming you are using the built in Hierarchy from Power BI for Dates? You won't be able to change this.

     

    You can try the following.

    • Open Power Query
    • Go to the table with the Dates.
    • Highlight the Update Date Column
    • Go to the ribbon and the Add Column tab
    • Click on Date and Choose Year and rename to Update Year
    • Repeat the above and choose Month Name and Rename to Update Month
    • Repeat the above and choose Month and Rename to Month Num Update
    • Repeat the above for the End Date
    • Load the data into the report
    • In the data view highlight the Update Month column and in the ribbon, choose Sort by and then choose Month No Update
    • Repeat for End Month and Sort by Month Number End

    Add the columns in the table Year first then Month

     

    Hope this helps

     

    Joe 

    If this post helps, then please Accept it as the solution

     

4 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    2 years ago

    Hi Anonymous 

     

    From where are the date fields coming from? Can you share a screenshot of the table in Data View? 

     

    Thanks

    Joe

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      The date fields are coming from distinct date entries. 

       

      One is the Update date and one is the End date. 

      • JoeBarry's avatar
        JoeBarry
        Solution Sage
        2 years ago

        This is a wild guess on what you are trying to acheive. I'm presuming you are using the built in Hierarchy from Power BI for Dates? You won't be able to change this.

         

        You can try the following.

        • Open Power Query
        • Go to the table with the Dates.
        • Highlight the Update Date Column
        • Go to the ribbon and the Add Column tab
        • Click on Date and Choose Year and rename to Update Year
        • Repeat the above and choose Month Name and Rename to Update Month
        • Repeat the above and choose Month and Rename to Month Num Update
        • Repeat the above for the End Date
        • Load the data into the report
        • In the data view highlight the Update Month column and in the ribbon, choose Sort by and then choose Month No Update
        • Repeat for End Month and Sort by Month Number End

        Add the columns in the table Year first then Month

         

        Hope this helps

         

        Joe 

        If this post helps, then please Accept it as the solution