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