Forum Discussion

siddrow's avatar
siddrow
Helper III
1 year ago

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 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

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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