Forum Discussion

sy898661's avatar
sy898661
Icon for Helper V rankHelper V
8 years ago
Solved

Rearrage the X-Axis

Hi all, I am trying to create a bar chart visual for number of crashes per month, but I was wondering if there was a way in PBI to rearrage the x axis so the first bar is the most recent month (as i...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI sy898661,

     

    I think sort by column option will suitable for your requirement, please refer to below link to know more about this feature:

    Sort by column in Power BI Desktop

     

    BTW, if you use numeric value as axis, it will disable sort options so you can't find it on visual.(normally click on '...' and you'll find these options)

     

    Regards,

    Xiaoxin Sheng

  • johnmu's avatar
    johnmu
    8 years ago

    Could you use relative date filtering?

     

    Set the date field to the visual level filter --> set filter type to relative date filtering --> set show items when the value is in the next XX months --> set include today to checked.

     

     

johnmu's avatar
johnmu
Icon for Helper I rankHelper I
8 years ago

Could you use relative date filtering?

 

Set the date field to the visual level filter --> set filter type to relative date filtering --> set show items when the value is in the next XX months --> set include today to checked.