March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I am trying to create a bar graph for the last 13 calendar month say april 2021- april 2022, but my bar graph shows visual from jan 2021-dec 2021 . My filters are correct but not sure what is not working
Solved! Go to Solution.
I'd say it's showing the data for Apr 2021 - Apr 2022, but since you're showing per month, some months are showing the aggregated data for both 2021 and 2022, if that makes sense.
if you want to see Year-Month, you need to click on the arrow that's fanning out from one arrow to two arrows when drilling down (the 4th drill down arrows from the left). If you try to normally drill down from year to month, you'd get what you're currently seeing.
Hope this helps!
Hi @Anonymous ,
For this type of error, it is because the hierarchy of your x-axis is restricted to months only, so even if you set the filter results for april 2021- april 2022 (based on days), it will not be displayed in the visual object.
Need to add day to the hierarchy.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
For this type of error, it is because the hierarchy of your x-axis is restricted to months only, so even if you set the filter results for april 2021- april 2022 (based on days), it will not be displayed in the visual object.
Need to add day to the hierarchy.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'd say it's showing the data for Apr 2021 - Apr 2022, but since you're showing per month, some months are showing the aggregated data for both 2021 and 2022, if that makes sense.
if you want to see Year-Month, you need to click on the arrow that's fanning out from one arrow to two arrows when drilling down (the 4th drill down arrows from the left). If you try to normally drill down from year to month, you'd get what you're currently seeing.
Hope this helps!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
91 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |