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

alanhodgson's avatar
alanhodgson
Solution Supplier
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

kgriendling's avatar
kgriendling
Advocate I
9 years ago

Perfect!