Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Anonymous
Not applicable

bar graph for last 13 calendar months

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 issue with bar graph.JPG

2 ACCEPTED SOLUTIONS
YukiK
Impactful Individual
Impactful Individual

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!

View solution in original post

v-henryk-mstf
Community Support
Community Support

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.

vhenrykmstf_1-1653902090621.png

 

vhenrykmstf_0-1653902070871.png

Need to add day to the hierarchy.

vhenrykmstf_2-1653902205621.png


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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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.

vhenrykmstf_1-1653902090621.png

 

vhenrykmstf_0-1653902070871.png

Need to add day to the hierarchy.

vhenrykmstf_2-1653902205621.png


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.

YukiK
Impactful Individual
Impactful Individual

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!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.