Hi there. I'm not sure if this is a question about custom columns or filtering. I'm looking at a data set that begins in Oct 24, and continues thereafter. As things currently stand, I need the visuals to show Oct 24, Nov 24, Dec 24, and Jan 25. If I filter the date hierarchy to month and year, though, it shows everything from Jan 24 to Jan 25 because I'm asking it to end on a Jan, e.g.
This is the same if I try 'on or after 1st Oct 24'. If I filter Oct, Nov, Dec and Jan, again it shows those across both years:
And I can't filter the year, because the data crosses 2024, 2025, and will continue.
I'm not sure if I'd benefit from a financial year style column, or if there's a way to filter better. To note, I can't filter out zero values because sometimes 0% might be correct data. It just happens that there were no 0% between Oct 24 - Jan 25. However, if I were to filter out zero values, this is what it looks like - this is how I want it to look, just without removing zero values!
Hi @AC23VM
I would use either the start or end of month in lieu of a date hierarchy so I could enable a continuous X-Axis and just format the date in the visual itself to month and year. I would also group the dates in their respective FYs. Please see the attached sample pbix.
