Forum Discussion

RMDNA's avatar
RMDNA
Solution Sage
8 years ago
Solved

Condense x-axis labels

Hi all,   I'm recreating a report (due to some issues with composite models), and I can't get the axis of the new chart to display labels like the old one did. In pic 1,the axis has dates listed a ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi RMDNA

    As tested, when the data type of this column is set to be text, it is not possible to find Type "categorical or continuous" under X-Axis.

    Please set the data type to "date" type.

     

    Best Regards

    Maggie

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

In your X-Axis card in the Format pane, switch to Continuous instead of Categorical

RMDNA's avatar
RMDNA
Solution Sage
8 years ago

Greg_Deckler,

 

Sorry, should have included this in my OP - that was my first thought, but I'm not seeing it in my x-axis options. I'm using the most recent Power BI Desktop x64 release.

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Are you sure that your column is set to Date or Date/Time and not Text?