Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i have a report with a table, can i order a report for multiple columns in the view?
thanks
Solved! Go to Solution.
Hi @momodj20 ,
We can create a calculated column to order it like following example,
Index = VAR p = [Power Level] VAR n = [Name] VAR a = [Age] VAR t1 = 'Table3' VAR t2 = FILTER ( 'Table3', 'Table3'[Power Level] = p ) VAR t3 = FILTER ( 'Table3', 'Table3'[Power Level] = p && 'Table3'[Age] = a ) RETURN RANKX ( t1, RANKX ( t1, [Power Level],, ASC, SKIP ) * 100 + RANKX ( t2, [Age],, ASC, SKIP ) * 10 + RANKX ( t3, [Name],, ASC, SKIP ), , DESC, SKIP )
This will sort by Power Level, then Age, and at last sort by name order.
Then if you want to see the order in Data view, just sort by index column.
If you want to see order in table visual, you can put the column into the table visual.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @momodj20 ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @momodj20 ,
We can create a calculated column to order it like following example,
Index = VAR p = [Power Level] VAR n = [Name] VAR a = [Age] VAR t1 = 'Table3' VAR t2 = FILTER ( 'Table3', 'Table3'[Power Level] = p ) VAR t3 = FILTER ( 'Table3', 'Table3'[Power Level] = p && 'Table3'[Age] = a ) RETURN RANKX ( t1, RANKX ( t1, [Power Level],, ASC, SKIP ) * 100 + RANKX ( t2, [Age],, ASC, SKIP ) * 10 + RANKX ( t3, [Name],, ASC, SKIP ), , DESC, SKIP )
This will sort by Power Level, then Age, and at last sort by name order.
Then if you want to see the order in Data view, just sort by index column.
If you want to see order in table visual, you can put the column into the table visual.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |