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
4 Replies
Hi,
try using the filter pannel and filter the Y axis value greater than 0.
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
