Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I am working with live data(Direct Query). I wanted to plot the number of events that occurred every hour for the last 48 hours broken down by each hour. I am able to plot the data but I am print the X-axis in descending order. My plot looks like this:
Here I want to print the X-axis from 48 to 1 instead of on 1 to 48. Could anyone kindly let me know how to plot the X-axis in descending order.
Many thanks in advance
Solved! Go to Solution.
In the upper right of the chart, click on the ellipses and the sort icon and sort by the hours column, descending. It has to be text though.
It cannot sort the axis of a chart if the axis is numerical, it always goes ascending.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIn the upper right of the chart, click on the ellipses and the sort icon and sort by the hours column, descending. It has to be text though.
It cannot sort the axis of a chart if the axis is numerical, it always goes ascending.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.