topic Re: Remove X axis dates with no data values in Desktop

Remove X axis dates with no data values

Anonymous — Wed, 03 Feb 2021 13:31:58 GMT

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

Re: Remove X axis dates with no data values

santiagomur — Wed, 03 Feb 2021 13:42:00 GMT

Hi,

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

Re: Remove X axis dates with no data values

Anonymous — Wed, 03 Feb 2021 13:50:46 GMT

Thanks, tried that but still didn't work

Re: Remove X axis dates with no data values

v-deddai1-msft — Fri, 05 Feb 2021 05:50:47 GMT

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

Re: Remove X axis dates with no data values

Anonymous — Mon, 27 Nov 2023 16:27:33 GMT

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