Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to remove data hierarchy from visualizations in new update

Hi! So for one of my datasets, I have a end of month date (1/31/2022, 2/28/2022, etc.) PowerBI automatically creates a data hierarchy, which is good, as I use that hierarchy in other places. However, in my table visualization, I just need it to show the date. 

 

In the previous version(s) of PowerBI, I could go to the field on the visualization pane and switch from Data Hirearchy to "End of Month". However, it doesn't appear that I can do this in the new update. Has anyone figured out a workaround for this? 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    This is my desktop version.

    Select [date] for the date column.

    Or we can create a column.

    Column = FORMAT('Table'[date],"mm/dd/yyyy")

     

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

     

     

2 Replies

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous just add sliceer and drag date column as you wish. I hope this help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    This is my desktop version.

    Select [date] for the date column.

    Or we can create a column.

    Column = FORMAT('Table'[date],"mm/dd/yyyy")

     

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.