Forum Discussion

brianf408's avatar
brianf408
New Member
10 years ago

Date formatting on X-axis

I am having some trouble with dates on the X-axis for an area chart.  I am pulling a daily report and target sheet that is broken down by day for a 6-month period.  The chart is only pulling randomly...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

brianf408, I am with greggyb on this one, can't reproduce randomly selected dates. Are you on the January update of Power BI Desktop or are you in Desktop? This was posted in Developer forum. I am using standard Area chart visualization in Desktop. I vaguely recall in earlier versions that sometimes if there were lots of dates that things like line charts and such would display a "representative set" of dates in the x-axis but I think that was in Excel with Power Pivot a long time ago and I believe that all of the values were actually there, just not every date displayed in the axis.

 

You can see screen shot below:

 

  • curtisp's avatar
    curtisp
    Helper II
    10 years ago

     

    Has this changed in Power BI yet?  

     

    Power  BI does a sampling of data if the number of records being aggregated to present data by x-axis values is too much to show on chart.  

     

    The solution is to do aggregation by date and then chart that aggregated data  or to reduce the number of records being presented on chart eg 2 months instead of 6 months. Neither is ideal. I want my viz tool to do that work for me.