Forum Discussion

venug's avatar
venug
Icon for Helper II rankHelper II
6 years ago
Solved

Dynamic X-Axis not sorting order in Stacked Column Chart

Hi Everyone,   i am tring to showcase my sales by price bucket wise. the X-Axis is dynamic. when i made dynamic X-Axis, i am unable to set sorting order in X-Axis.   Can any one help on this. tha...
Need Help
  • saraMissBI's avatar
    saraMissBI
    6 years ago

    Hi venug,

    To get what you want try to drag and drop "Price-Tier-Sort" into Value not Axis. You should have the ability to sort by "Price-Tier-Sort" from the three dots on the top right corner of the chart, and you will need to change the title of the Y-Axis to just "Sales". Please check the link where I updated your report here

     

    Please give kudos and mark as solution

    Thank you!

     

elaine_shy's avatar
elaine_shy
Regular Visitor
4 years ago

Hi, I am facing similar issues, I have created a dynamic x axis for my histogram, and the axis range changes according to the paremeter i set in powerquery. In this case, how can i make sure to sort my bar charts so it the axis is in a linear order(i.e. 0 to 10, 10 to 20, 20-30[note: my axis changes according to my parameter and also my histogram is different for every factory i filtered])