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. thanks in advance, see my file in this link.

 

Regards

Venu

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!

     

12 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi venug,

    In your sacenario, I saw you have sorted the chart by Price-Tie. I am not clear abut your requirement, what did you want to sort by? which dynamic chart did you want to get, could you please inform me in details?

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

      Thanks a lot for reply,

       

      when i provide "price-tier-sort" column in x-axis it is showing sort order. when removing it is not showing sort order.

       

      in this scenario, it should not show "price-tier-sort" in x-aixs, that improper visual. 

       

      this is the complexity i am facing. 

       

      Please any body help on this. thanks in advance.

       

      Regards

      Venu

      • saraMissBI's avatar
        saraMissBI
        Icon for Resolver I rankResolver I
        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])