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
- AnonymousNot 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
Microsoft 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
Microsoft 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.