Forum Discussion

kgriendling's avatar
kgriendling
Advocate I
9 years ago
Solved

How to Hide Empty Dates

Hi,   For some reason PowerBI desktop decided to include dates that aren't even in the data spreadsheet.   Any ideas how I can get ride of these?   In excel it is as follows:   Jun 16 Jun 25...
Need Help
  • alanhodgson's avatar
    alanhodgson
    9 years ago

    kgriendling,

     

    Just as I suspected, you need to change the formatting on the graphs. Navigate to the Format paintbrush once you have selected the visual, then under "X-Axis" and "Type", change it to "Categorical".

     

    Let me know if that works or if I need to provide a screenshot.

     

    Thanks,

     

    Alan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am having this same issue! Although, I don't have the "Type" option under the "X axis" format field. 

I am using Version: 2.68.5432.761 64-bit (April 2019)

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

The legend field is not in the Paint section; it is one of the field in the line chart itself.  Click on the line chart.  It will be the entry below Axis.