https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Disable-table-visualization-s-order/m-p/2706234#M4905 <P>hi, i have an excel table like this:</P><P><STRONG>Metrics&nbsp; &nbsp; &nbsp; &nbsp;Figures</STRONG></P><P>Loan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12</P><P>Provision&nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>Write-offs&nbsp; &nbsp; &nbsp; 1.5</P><P>Net losses&nbsp; &nbsp; &nbsp; 2</P><P>&nbsp;</P><P>I want my table visual to look exactly the same as in the above table. However, PB automatically sort the table based on the Metrics column. The output looks like this:</P><P><STRONG>Metrics&nbsp; &nbsp; &nbsp; &nbsp;Figures</STRONG></P><P>Loan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...</P><P>Net losses&nbsp; &nbsp; &nbsp;...</P><P>Provision&nbsp; &nbsp; &nbsp; &nbsp;...</P><P>Write-offs&nbsp; &nbsp; &nbsp;...</P><P>&nbsp;</P><P>How may I fix this issue? Thank you in advance!</P> Wed, 17 Aug 2022 10:13:40 GMT khue98 2022-08-17T10:13:40Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Disable-table-visualization-s-order/m-p/2706234#M4905 <P>hi, i have an excel table like this:</P><P><STRONG>Metrics&nbsp; &nbsp; &nbsp; &nbsp;Figures</STRONG></P><P>Loan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12</P><P>Provision&nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>Write-offs&nbsp; &nbsp; &nbsp; 1.5</P><P>Net losses&nbsp; &nbsp; &nbsp; 2</P><P>&nbsp;</P><P>I want my table visual to look exactly the same as in the above table. However, PB automatically sort the table based on the Metrics column. The output looks like this:</P><P><STRONG>Metrics&nbsp; &nbsp; &nbsp; &nbsp;Figures</STRONG></P><P>Loan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...</P><P>Net losses&nbsp; &nbsp; &nbsp;...</P><P>Provision&nbsp; &nbsp; &nbsp; &nbsp;...</P><P>Write-offs&nbsp; &nbsp; &nbsp;...</P><P>&nbsp;</P><P>How may I fix this issue? Thank you in advance!</P> Wed, 17 Aug 2022 10:13:40 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Disable-table-visualization-s-order/m-p/2706234#M4905 khue98 2022-08-17T10:13:40Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Disable-table-visualization-s-order/m-p/2713024#M4917 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="427847" data-lia-user-login="khue98" class="lia-mention lia-mention-user">khue98</a>&nbsp;<BR /><BR />In the top right corner of the visual in the ... options is where the default sort order can be set.&nbsp; There is the option to base the sorting on the dimension or the measure.&nbsp;<BR /><BR /></P><P><img /><BR /><BR /><BR />Please note your metrics are conveniently sorted A-Z.&nbsp; If you want to change to non-A-Z order you need to add a Sort Key and then set the "Sort by Column" option.&nbsp;&nbsp;<A href="https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop" target="_blank">Sort one column by another column in Power BI - Power BI | Microsoft Docs</A><BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 19 Aug 2022 16:08:26 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Disable-table-visualization-s-order/m-p/2713024#M4917 Anonymous 2022-08-19T16:08:26Z