The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 with 10, 11, and so on.
Above is the table I use, how can i correctly sort by ascending order?
Thanks!!
Solved! Go to Solution.
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
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.
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!
I attach the pbix, it contains the index column
https://1drv.ms/u/s!ApgeWwGTKtFdhiTj1pBzxG_8LkDW?e=SQDJ4f
In case you want to look and see the problem
Thanks 🙂
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
Hey @o59393 ,
you have to create an index column and then use this column to sort the column label by this new column.
This article describes how you can sort the label column by another column: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hopefully this provides what you are looking for.
Regards,
Tom
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
56 |
User | Count |
---|---|
256 | |
120 | |
112 | |
83 | |
71 |