deepakyadav's avatar
deepakyadav
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Status:
Investigating

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

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

3 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    deepakyadav
    Icon for Microsoft Employee rankMicrosoft Employee

    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's avatar
    deepakyadav
    Icon for Microsoft Employee rankMicrosoft Employee

    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.