Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 in, instead of it showing as Jan, Feb, Mar...etc, it would show as June, July, Aug, ...)
Thank you!
Solved! Go to Solution.
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
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.
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.
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
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |