Sorting Table Columns Based On Vaules

Question

Hi all,&nbsp;So I have a table and I would like to dynamically change the order of the columns based on the values in the top row.&nbsp;So the table below:&nbsp;&nbsp;Test1Test2Test3Test4Test5Test6Test7Test809/09/201718%0%14%11%0%0%11%0%16/09/20170%0%0%0%0%0%0%0%23/09/201717%3%3%0%0%0%0%0%30/09/20175%2%5%0%0%0%0%0%07/10/201717%3%4%0%0%0%0%0%14/10/20175%7%2%0%0%0%0%0%21/10/201715%5%3%0%0%0%0%0%28/10/201717%0%0%0%0%0%0%0%04/11/20171%2%1%0%0%0%0%0%11/11/20170%0%2%0%0%0%0%0%&nbsp;Would dynamically change to :&nbsp;&nbsp;Test1Test3Test4Test7Test2Test5Test6Test809/09/201718%14%11%11%0%0%0%0%16/09/20170%0%0%0%0%0%0%0%23/09/201717%3%0%0%3%0%0%0%30/09/20175%5%0%0%2%0%0%0%07/10/201717%4%0%0%3%0%0%0%14/10/20175%2%0%0%7%0%0%0%21/10/201715%3%0%0%5%0%0%0%28/10/201717%0%0%0%0%0%0%0%04/11/20171%1%0%0%2%0%0%0%11/11/20170%2%0%0%0%0%0%0%&nbsp;Is this possible in Power BI?&nbsp;Cheers,&nbsp;Michael.

anonymous · Accepted Answer

Anonymous,It is not possible to dynamically change the order of the columns as you describe. In Query Editor, you can manually reorder the columns. Or you can create a table visual with the order you want.&nbsp;Regards,Lydia

Forum Discussion

Sorting Table Columns Based On Vaules

2 Replies

Related content

Sort by another column

Column Chart sorting

Sorting

Table Sort , sort order , comparer

sorting matrix

	Test1	Test2	Test3	Test4	Test5	Test6	Test7	Test8
09/09/2017	18%	0%	14%	11%	0%	0%	11%	0%
16/09/2017	0%	0%	0%	0%	0%	0%	0%	0%
23/09/2017	17%	3%	3%	0%	0%	0%	0%	0%
30/09/2017	5%	2%	5%	0%	0%	0%	0%	0%
07/10/2017	17%	3%	4%	0%	0%	0%	0%	0%
14/10/2017	5%	7%	2%	0%	0%	0%	0%	0%
21/10/2017	15%	5%	3%	0%	0%	0%	0%	0%
28/10/2017	17%	0%	0%	0%	0%	0%	0%	0%
04/11/2017	1%	2%	1%	0%	0%	0%	0%	0%
11/11/2017	0%	0%	2%	0%	0%	0%	0%	0%