https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-sort-based-on-all-data-for-custom-visuals/m-p/795520#M2564 <P>So lets say I have a dataset with 10,000 values. These values are simply 1-10,000</P><P>&nbsp;</P><P>I load batches with 100 values at a time. When I call sort on my custom table by ascending, I get 100, 99, 98 etc. But what I really want is for the sort to query the database, and return the values 10,000, 9999, 9998 etc.</P><P>&nbsp;</P><P>Is this possible? I want to avoid using the filter pane if possible. I noticed that the original tables make a querydata call when sorting values. How can I replicate this?</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 18 Sep 2019 09:14:33 GMT Anonymous 2019-09-18T09:14:33Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-sort-based-on-all-data-for-custom-visuals/m-p/795520#M2564 <P>So lets say I have a dataset with 10,000 values. These values are simply 1-10,000</P><P>&nbsp;</P><P>I load batches with 100 values at a time. When I call sort on my custom table by ascending, I get 100, 99, 98 etc. But what I really want is for the sort to query the database, and return the values 10,000, 9999, 9998 etc.</P><P>&nbsp;</P><P>Is this possible? I want to avoid using the filter pane if possible. I noticed that the original tables make a querydata call when sorting values. How can I replicate this?</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 18 Sep 2019 09:14:33 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-sort-based-on-all-data-for-custom-visuals/m-p/795520#M2564 Anonymous 2019-09-18T09:14:33Z