Display all values for x axis of hours
I have a graph, which shows data of hours on x axis, i'm also using a slicer to display data of spesific group. However its not showing the wwhole hours (my data is displaying hours till 10) Is there any way to display the whole hours even if there is no data? i tried to check show item with no data and put z-axix to categorical I'm not using any measures here, its just counting no of values per hour Also, i can not upload any data as i'm a new joiner
Sorting 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:
