Hi
I am using a date (year and month hierachy) in the X-axis and a % measure in the Y-axis. I would like to only filter on data from the current financial year (1/7/24 - 30/6/25). My chart is still showing previous years in the X-axis with no value, even though I have filtered on the date range I'd like in filters pane.
thanks in advance
Hi @siddrow ,
Are you using the Auto datetime auto-generated date hierarchy and measure +0 to make sure you have data for each month?
1. Disable the Auto datetime option as much as possible and create and use a date hierarchy in the date table.
2. Try adding a visual filter where Measure is not 0, or remove the +0 at the end in measure.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
