Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

How to sort a graph by ascending order

Hi all   I need to sort a graph in descending order, the problem I have is that it recognizes for example a 15 before a 2, must be because it starts with 1.   As seen in the red graphs it starts ...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI o59393 

    Just add just the model as below:
    Step1:

    Use this formula to create Total Sanitary Reg Time Interval column

    Total Sanitary Reg Time Interval = calculate(FIRSTNONBLANK(dimIntervals[Label],1),FILTER(dimIntervals,dimIntervals[MinPeriod]<(Ticket[*Department time]+Ticket[Cycle Time (Process)]+Ticket[*Submission to government]) && dimIntervals[MaxPeriod]>=(Ticket[*Department time]+Ticket[Cycle Time (Process)]+Ticket[*Submission to government]) ))

    Step2:

    Create a relationship between 'Ticket' table and 'dimIntervals' table

     

    Step3:

    Now set sort by column and when you create visuals, use [Label] instead of [Total Sanitary Reg Time Interval]

     

    and here is sample pbix file, please try it.

     

    Regards,

    Lin

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago
It is happening because your label column is text.

Well, you should create an index column by applying the below steps:
1. go to query editor ans select your Label Column then go to Add column menu and select Index Column. So it will automatically creates index column for starting with 0. Apply and close query editor.
2. Go to Data view tab from left most panel and select Label Column then go to modelling menu then choose Sort by column option and check mark the Index Column.

Don't forget to give thumbs up 👍and accept this as a solution if it helps you.
o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi Tahreem24  and TomMartens 

 

When I create the index column and I select to sort by index in the label column the visuals crash:

 

How can I fix it ?


Thanks.

 

 

  • o59393's avatar
    o59393
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    I added the index to the visual and went from this:

     

     

     

    To this:

     

     

    I am getting everything with 100% when it should be the count of times as seen in the statement of the problem, how can I correct it?

     

    Thanks!

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        HI o59393 

        Just add just the model as below:
        Step1:

        Use this formula to create Total Sanitary Reg Time Interval column

        Total Sanitary Reg Time Interval = calculate(FIRSTNONBLANK(dimIntervals[Label],1),FILTER(dimIntervals,dimIntervals[MinPeriod]<(Ticket[*Department time]+Ticket[Cycle Time (Process)]+Ticket[*Submission to government]) && dimIntervals[MaxPeriod]>=(Ticket[*Department time]+Ticket[Cycle Time (Process)]+Ticket[*Submission to government]) ))

        Step2:

        Create a relationship between 'Ticket' table and 'dimIntervals' table

         

        Step3:

        Now set sort by column and when you create visuals, use [Label] instead of [Total Sanitary Reg Time Interval]

         

        and here is sample pbix file, please try it.

         

        Regards,

        Lin