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,
so I'm working on a big report including dates from 2016 and 2017,
for some reason the date hirrarchy mix dates from Q1 2016 and 2017.
I would like to present 5 Quarter, Q1 2016 Q2 2016 Q3 2016 Q4 2016 Q1 2017 - for all times the data is dynamic so the solution should be permanent.
please help
Solved! Go to Solution.
Hi @Noak,
I agree with BetterCallFrank's solution. Below is a sample about how to use it:
1. Add a calculate column to store the "quarter year".
Year-Quarter = CONCATENATE([Date].[Quarter]," "& [Date].[Year])
2. Drag the new column as the axis field and remove the original date column which in your visual.
Regards,
Xiaoxin Sheng
Hi @Noak,
I agree with BetterCallFrank's solution. Below is a sample about how to use it:
1. Add a calculate column to store the "quarter year".
Year-Quarter = CONCATENATE([Date].[Quarter]," "& [Date].[Year])
2. Drag the new column as the axis field and remove the original date column which in your visual.
Regards,
Xiaoxin Sheng
solved i repleased the year with quarter in order to have logic.
Year-Quarter = CONCATENATE( [createdon].[Year]," " & [createdon].[Quarter])
thank you!.
hi @v-shex-msft
I alreday figured it on my own , problem is the order as you can see:
Q1 -2017 Should be the latest.
you have to add the year from the date hierarchy to X-axis - this will separate q1/16 from q1/17
HTH,
Frank
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |