Forum Discussion
Remove X axis dates with no data values
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
Hi Anonymous ,
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%2Daxis%20select,to%20hide%20values%20without%20data.
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
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