Forum Discussion

kitti's avatar
kitti
Icon for Helper III rankHelper III
6 years ago
Solved

Multiple date hierarchies in the same visual

Hello experts, I want to have a bar visual that displays multiple date hierarchies on the X axis. For example, on the left, it displays aggregated data for 2019/Q4 and then by January, February, ...
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi kitti ,

     

    Yo can create calculated columns for year, quarter, month, week, and then use these columns to create new hierarchy.

    Year = [Date].[Year]
Quarter = [Date].[QuarterNo]
Month = [Date].[Month]
Week = WEEKDAY( [Date] )

     

    Best regards,
    Lionel Chen

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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

kitti , You create the required column in you date table and create custom hierarchy

https://www.youtube.com/watch?v=WWvVeYU0Dvw

 

How to create various column

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/