Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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, and Sea month, after that it shows week1, week2, April week3, and then is displayed as a day until the last day.
How do you model the data so you can visualize it like this? Is it possible in Power BI?
Thank you
In
Solved! Go to Solution.
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.
Hi,
Not yet sir, sorry for late update. I want something like this
Would you please help?
Thanks,
KL
Hi All,
I will try those methods, but it's going to take some time to study. Then I will come back with the results. Thanks!!
KL
Hi @kitti ,
Has your problem been solved? If yes, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Lionel Chen
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.
@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
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |