bar graph for last 13 calendar months

[Anonymous]

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 

[YukiK · Accepted 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!

[v-henryk-mstf · Accepted solution]

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.

[YukiK · Accepted 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!