The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have read a host of articles on this topic, but have yet to identify a clear answer in how to solution this.
How do I create a hierarchy - or even a month / quarter view - that remains a time series?
Essentially, I am currently using the default date hierarchy of Day, Month, Quarter, Year on my X-axis, and as I move through the hierarchy, Day, Month and Quarter get aggregated; So instead of having 2019 Q1, 2019 Q2, 2019 Q3, 2019 Q4, 2020 Q1..., etc., it aggregates all the Q1's, Q2's, etc...
If you need the sample file, here is the link: https://drive.google.com/file/d/1yix9WVBmMgPhhyFowKDS4JigrGPEAluk/view?usp=sharing
Current (I don't want this):
Objective (Preferably in a Hierarchy, but even just Qtr or Mnth would be nice):
Solved! Go to Solution.
@Anonymous - I don't know man, it works perfectly fine for me. See attached PBIX below sig for configuration of visual.
@Anonymous - If I understand correctly, you would want to build the hiearchy from Year, Quarter, etc. and then use the forked drill down arroes, NOT the double parallel drill down arrows.
@Greg_Deckler That is definitely closer to what I am looking for. The issue with that approach is that the x-axis labels dont adjust. So even if the chart reflects months, it still only shows the year in the axis.
The larger part of my question is how do I create a time series chart for either month or quarter like in the image of my original question. I want the x-axis to reflect each quarter/month in a series of multiple years. It seems like a really obvious thing, so I am confused why PowerBI makes it so difficult.
@Anonymous , when you drag a date with Hierarchy or Year and Qtr on the visual on the axis. You will get drill down and drill expand icon. The reverse square Y. Try to use the expand icon
refer : https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
@amitchandak Sorry, but you have slightly misunderstood my question. My question is about having the hierarchy - or even just the Quarter or Date - be a CONTINUOUS timeseries that adjusts for each level. I don't want all the Q1's to aggregate, I want the axis to show 2019 Q1 and 2020 Q2 separate.
@Anonymous - I don't know man, it works perfectly fine for me. See attached PBIX below sig for configuration of visual.
I think I figured it out. To get mine to look like yours I had to turn my x-axis from continuous to categorical and turn off concatenate labels. Then it worked.
Thanks!
@Anonymous - Yes, that is how I did it as well. Cool, I figured it would be better to just ship it to you and let you compare settings as I was not quite certain how you had your visual configured. Now that you mention it, it's probably not super intuitive. Hmmm, maybe I've been doing this stuff for too long!! Anyway, hooray!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |