Advice on best method to sort - tried many things!
Hello. I would love some advice on the best method to custom sort dynamic data. I have a table of students' outcomes on various tests. These outcomes are categorical and change all the time. New tests are added to the data set frequently, as are new outcomes for those tests that already exist. I have tried a SUMMARIZE table, I have tried a reference table, and other methods that I am forgetting at the moment. In any case, I have been unsuccessful. Here is a portion of dummy data from the bigger, complete table of data. The "How I would like to sort" column is what I am attempting to accomplish. My end goal is to have bar graphs/matrices that display the following outcomes in the preferred order shown in the table below. Thank you for your input! Test Outcome How I would like to sort Test 1 Proficient 1 Test 1 Exemplary 2 Test 1 Developing 3 Test 1 Not Provided 4 Test 2 Above Proficient 1 Test 2 Proficient 2 Test 2 Below Proficient 3 Test 2 Not Addressed 4 Test 3 Excellent 1 Test 3 Satisfactory 2 Test 3 Needs improvement 3 Test 4 Excellent 1 Test 4 Satisfactory 2 Test 4 Inadequate 3 Test 5 Above Proficient 1 Test 5 Proficient 2 Test 5 Acceptable 3 Test 5 Unacceptable 4 Test 6 Exceeds Expectations 1 Test 6 Meets Expectations 2 Test 6 Below Expectations 3 Test 7 Exemplary 1 Test 7 Acceptable 2 Test 7 Needs Improvement 3 Test 7 Unacceptable 4
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.
How to sort TopN results based on a column not used in the function
Hello Power BI Community, Happy New Year to all! I am trying to get a solution for a peculiar request. I am populating a measure in matrix to get a skyline chart. My DAX measure is as follows: Skyline_Names = var Rank = SELECTEDVALUE( Skyline[Rows] ) var Count = DISTINCTCOUNT( Table1[Name] ) var stage = SELECTEDVALUE(Table1[Stages]) RETURN IF ( NOT ISBLANK ( Rank ), IF ( Rank <= Count, LASTNONBLANK ( TOPN ( Rank, VALUES(Table1[Name]),Table1[Name],ASC) ,0 ) ), stage ) Now, this is all fine and the values in matrix are sorted based on the alphabetical order of the Table1[Name], but I need to sort based on a different column. I highlighted the part where I need to sort based on a different column eg: Table1[Price]. I tried multiple functions like SELECTCOLUMN, RANKX, etc.. but did not succeed. I am including the source and PBIX file https://drive.google.com/drive/folders/1VdxQRTty-kxuHvurB8o-2cJkFhgcw2El?usp=sharing I really appreciate if you have any suggestions or can help me with this. Thank you in advance! Anonymous amitchandak Greg_Deckler ValtteriNSort Date and Value columns
Hello, I have a data that looks like below: I would like sort the DEP, DEC and DOM column in descendig order for whatever the date range EST (Datetime )Column is selected. Example if I select date 1/1/2020 and 1/2/2020 for both the dates it should arange the DEP DEC and DOM values form Highest to lowest. 1/1/2020 high to low and 2/2/2020 high to low, 1/3/2020 high to low. In current scenario If i try to order them in descending order it mixes the dates and hours by decending the values considering the full range of all dates. I would like to see High to low for each date selection. Please suggest me the DAX or any solution based on the column names I have. Thank you.
