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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello alanhodgson ,

     

    I have the same scenario but changing X-axis from Continuos to categorical in line and stacked column chart(combo chart) is not helping me in removing the spaces. Please find the below screenshots for your reference and please let me know how to proceed with this.

     

    Before changing to Categorical

     

    After changing it from Continuos to Categorical

     

     

  • kgriendling's avatar
    kgriendling
    Advocate I
    9 years ago

    Perfect!

  • 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!