ordering
2 TopicsPages explorer for easy handling of pages to reorder, hide, delete, etc...
It still amazes me that Power BI doesn't have a better way to handle pages. Having several pages mean that you need to drag-and-drop to reorder, you need to use the arrow keys (no scrollbar?) to go to the next ones, and all-in-all makes the experience poorer. It'll be great to have a pages explorer (similar to Word's bookmarks panel) where you can see all the pages (in vertical, please) and reorder, hide or delete them. It'll make a lot of people's life easier.6.7KViews0likes0CommentsSorting on X axis on created column
Hello, Am in need of assistance....I have a query returning "Elapsed minutes" as Whole Number data type. I created a new column, within PowerBI, which "categorizes" the value into "buckets of time". This created column is set up as: Time_Slot = IF(Mobile_Visit_Detail[Elapsed Time]< 10,"0-10", IF(Mobile_Visit_Detail[Elapsed Time]>=10&&Mobile_Visit_Detail[Elapsed Time]<=15,"10-15", IF(Mobile_Visit_Detail[Elapsed Time]>15&&Mobile_Visit_Detail[Elapsed Time]<=30,"15-30", IF(Mobile_Visit_Detail[Elapsed Time]>30&&Mobile_Visit_Detail[Elapsed Time]<=60,"30-60", IF(Mobile_Visit_Detail[Elapsed Time]>60&&Mobile_Visit_Detail[Elapsed Time]<=180,"60-180", IF(Mobile_Visit_Detail[Elapsed Time]>180&&Mobile_Visit_Detail[Elapsed Time]<=360,"180-360", IF(Mobile_Visit_Detail[Elapsed Time]>360&&Mobile_Visit_Detail[Elapsed Time]<=540,"360-540", IF(Mobile_Visit_Detail[Elapsed Time]>540&&Mobile_Visit_Detail[Elapsed Time]<=720,"540-720", "720 +")))))))) No matter which chart visual I use, I cannot get the sorting/ordering of the X axis (using the Time_Slot column) to sort in the ascedning "number of minutes" categories......Left to right should be: 0-10 10-15 15-30 30-60 60-180 180-360 360-540 540-720 720+ The visual displays in this order: 0-10, 10-15, 15-30, 180-360, 30-60, 60-180, 720+ There are two categories which have no counts. (Not displaying these two is not a problem, but an annoyance for me. Even if checking "Show items with no data", they don't display). The Time_Slot column is Data type of text. Changing it to whole number, or any other type doesn't work b/c of the dashes and the "+" in the 720+. What do I need to do to get this visual to display in Time_Slot ascending order with their corresponding values. Here's what the visual looks like now:Solved1.6KViews0likes8Comments