visualization issue with "Month" setting in Visualization for 2 month data

[deepakyadav]

Table contains data of 2 months only.

    When selected 'Month" from X-Axis visualization - it does not show current month (feb). It shows Jan 1, Jan15, Jan29.   
    It should shows show only Jan and feb months . See snapshot. It should not jan-15 and Jan-29 as there is no data for these dates..

   When the Select 'Date Hierarchy" - it shows correctly. it show both  jan and feb month.

Ii

[v-xiaoyan-msft]

Hi @deepakyadav ,

I did a simple test but did not reproduce your problem.
If you check the box the way I did does the problem still occur?

Version: 2.114.664.0 64-bit (February 2023)

Best regards.
Community Support Team_ Caitlyn

[deepakyadav]

The setting needs to be changed in "Visualization" Pane not in the "Data" pane.

Please see this pbix file - One_Drive_PBI_File 

Snapshots:

[deepakyadav]

The issue exist for 3 months data also with "Month" Setting. The below snapshot will make issue more clear.

Issues: March is not shown in above and jan-15, jan-29 dates which do not exist in Data are shown.