This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
So I noticed that in the August 2019 developer update, there was support API for sorting that is now available to developers for embedded visuals.
const request = {
orderBy: {
table: "SalesFact",
measure: "Total Category Volume"
},
direction: 2 // models.SortDirection.Descending
};
visual.sortBy(request);
https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-august-2019-update/
I'm now wondering if there is also API for sorting that is available to Custom Visuals, such that I can sort based on buttons that I have placed inside the visual. Right now I'm using a very ghetto approach with TopNFilters and batch loading that works fundamentally, but has some bugs and is complex to implement.
I'm also curious about how the native table can call the sort API, if you could expose the code for that sort section, it would help immensely with my issues.
Thanks
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.