Forum Discussion

kitti's avatar
kitti
Helper 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.

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
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.