Forum Discussion
Stacked Column Chart Error
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 sti...
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