![]() ![]() any missed amounts will cause the row to return a blank and will vanish from your report until the table is fixed. The upper limit of row 1 must be $1 less than the lower limit of row 2, etc. You will have to be careful though that no values are missed. ![]() A SharePoint list, for example where the ranges can be tweaked and then the report updates as applicable. Your Spend Sort table should be something your boss can easily edit. That will return 1, 2, 3, or 4 based on the data in my Range Sort table. In fact, you can just ignore the ">$1K and = 'Spend Sort' If I've not met your goal or you have questions, let me know! See Sort By Columns article for specifics on what I did there if you aren't aware of that feature. Then dropped the fields in this matrix and told it to sort the Range by the Range Sort field in the Modeling tab. ![]() Then in the model, I related this Range table to my data table. However, if you have visits above 9, you'd need to do the same type of table since 10 would sort before 4 alphabetically. There was no need for the Visit ranges since as labeled, alphabetical sort would work. VisitCount >= 0 & VisitCount = 4 & VisitCount = 7 & VisitCount <= 0, "7 - 9"īecause the Spend Ranges will not sort properly, I created a new table in Power BI to just have the ranges and the sort priority: SpendRange >= 2001 & SpendRange 2K - 3K", SpendRange >= 0 & SpendRange = 1001 & SpendRange 1K - 2K", I created 2 calculated columns to get the visit and spend ranges: ![]()
0 Comments
Leave a Reply. |