Microsoft Sankey Visual: How can I prevent destination nodes being automatically reordered?
Hi all, I'm using the Microsoft Sankey visual in Power BI Desktop and would like to keep the node order consistent between the left and right sides of the chart. My source data is structured as: From To Value Apples Apples 45 Apples Pears 7 Pears Fig 26 Fig Cherry 115 Cherry Cherry 13 Intended category order: Apple Pear Fig Cherry However, the Sankey visual automatically changes the order of the destination nodes presumably to reduce flow crossings. I have already tried: Creating a numeric sort column (1 = Severe, 2 = Moderate, 3 = Mild, 4 = Normal renal function) Using Sort by Column on the destination field (To) Creating a separate Category/SortOrder lookup table Sorting both the source data and lookup table correctly Disabling Auto links reorder in the visual settings Power BI accepts the sort order without errors, but the Sankey visual continues to reorder the destination nodes. Manually dragging is not ideal, as the freehand movement does not allow precision. My questions are: Does the Microsoft Sankey visual support a fixed destination node order? Is there a supported way to force the same category order on both sides of the Sankey Any advice would be greatly appreciated. Thanks!
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
Sort By Absolute Value
I frequently find myself building Absolute value calcs just so I can sort on them to find offseting rows. Occassionaly I hit an obvious circlular ref error when I try to select the ABS calc as the sortby column for the original. Adding the ABS Column fixes that and allows for grouping and such, but it is annoying that I even need to build the calc, when all I really want is to sort by the absolute value and I suspect others would benefit with a sort on ABS toggle. I think this has application in any numeric list hence not specifying the visual
Sorting/filter data by particular month in line chart
Hello all, I have a query about sorting data in a particular month in line chart. Line chart is showing a series of data, example as below. At the moment, my top 5 item groups are sorted by total value of item groups. What if at each month, I need to sort the data in descending order for that particular month, how do I do it in filter or DAX? It’s easy in excel by just sorting a particular column, but I don’t know how to do it in Power BI. As I’m sorting item group orders at each month, which means my top 5 item groups will be different as at each month.Need help in DAX in Line Chart
Experts, please help me on DAX column for sorting the current year & previous year. The scenario is, we have one date column which holds the data for last 365 days and we have a requirement to show 2 lines on the Y-Axix i.e. one is for current year & previous year for comparing both year values. But, unfortunatley when we see on the current date it it is broken the line for previous year. please help?Dynamic table sorting based on total count with fixed value at the bottom
Hi, I want to sort this table dynamically. So that the color category with the highest count is at the top, and the lowest at the bottom, but, I want "Unknown", to always be the last value in the table even though it has a high count. How do I do this? Thanks in advance, highly appreciate it 🙂
Dynamic Sorting stacked bar chart based on slicer value
I have one slicer and 3 Stacked bar charts and this bar chart contains only X-axis and legends. In my slicer, I have values like 1,2,3,4 when I select 1 or 2, or 3 my stacked bar chart should sort according to alphabetic order but instead of these three when I select 4 My stacked bar chart has to be sorted based on legend value, not the alphabet. Thank you in advance for whatever effort you are giving into this problem.
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:Legend and Stacked column both in same order..has this been solved
The Column is sorting with first name in Legend on the bottom and last Name on top. Is there a way to have it sort with last name on bottom of stack and first name on top for better readability? I've tried things from other posts, but nothing works. I also saw to vote for feature, but looks like this request has been out there for years with no progress. Please help out a girl. 🙂
