Remove X axis dates with no data values

[nsaray]

Hi - is there a way to hide the months that don't have values? My graph ends up being too long and  don't want users to scroll 

Thanks

[PaulShlapa]

Does anyone know if it would be possible to achieve the same result using a slicer instead? I would like to be able to switch between month with the data and without. Thanks

[v-deddai1-msft · Accepted solution]

Hi @nsaray ,

Did you have a date table in your model and use the date column from the date table? And please check if you select show item with no data(uncheck it).

Would you please show us sample pbix if the issue is still existing? And you can also refer to the similiar post: https://community.powerbi.com/t5/Desktop/Remove-dates-with-no-data/m-p/561214#:~:text=On%20the%20X%2....

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[santiagomur]

Hi, 

try using the filter pannel and filter the Y axis value greater than 0. 

[nsaray]

Thanks, tried that but still didn't work