Forum Discussion

kgriendling's avatar
kgriendling
Icon for Advocate I rankAdvocate 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
Icon for Solution Supplier rankSolution 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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Wow... what to say. KISS. Kit it simple...ME!

 

Thanks alot for reminding me, this so basic feature that i forgotted and was having a issue with that!