Decomposition tree sort value Desktop vs Server changing
Hi There, My issue is very simple. When I publish a report on PBI server, the sort applied to a decomposition tree (Descending by value) is not respected and instead it sorts descending alphabetically. Desktop: Server: What I tried: - Check a similar post on the community: https://community.powerbi.com/t5/Service/Decomposition-Tree-has-no-default-sort-on-my-online-report/m-p/1206762#M101791 This does not apply to my issue as I do not want to sort the values on the dataset. - Revert to default on the server. It doesn't work, the sort alphabetically is the default on the server - Edit on the server and Sort but the only option is an Alphabetical sort: Did anyone run into this issue before? Regards, Alex
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:
Custom Theme Data Colors not in Proper Order
Hi all, I'm using PowerBI Desktop (January 2020) for Report Server. I have a dashboard that pulls flat data from a single table, with multiple data types represented in multiple visualizations, i.e. one visualization shows Research in Millions of Dollars from 2013 - 2018, one visualization shows Doctoral Graduation Rates from 2013 - 2018, and so on. My issue is that some visualizations also are showing 2012, but 2012 is now the darkest shade of blue, which is inconsistent with the rest of the visualizations having darker colors for more recent years. I was wondering if anyone could help me order these colors correctly. I've tried using a Conditional Column to order my color scheme, as was done in this post by v-lili6-msft, but it appears I cannot select Field Data Color, and then select Modeling -> Sort by Column. I thought this might be due to the edition of PowerBI I was using. Thanks!
