pbiideas1New Member12 years agoStatus: CompletedTop N Filters Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
yoshihiroNew Member6 years ago"Top 10" is so easy rather than creating new Measure = IF ( HASONEVALUE( .. ), RANKX( ALL (...) , CALCUATE ( ... ) and Filter.
Recent ideasAll Idea StatusesNewNeed ClarificationNeeds VotesUnder ReviewPlannedCompletedAbandonedTagged:TagMost RecentLet Workspace Admins manage Fabric Policies For example, allow a Workspace Admin to grant other identities the Contributor role, while also granting them higher privileges in certain areas, e.g. List Workspace role permissions (without resha...Workspace Identities - Sharepoint Power Bi workspace Identities should work with SharePoint data set & sources. So you can add the related workspace identity directly to SharePoint without the need to use the graph API or tokens. Settings to Auto Delete SQL Queries SQL queries in a Fabric Warehouse, Lakehouse, etc. save automatically with a generic name, e.g. SQL query 1. While there have been improvements to allow for bulk deleting, I would suggest adding the...Support for nested WITH statements TL;DR: nested WITH statements are supported in all modern data warehouses, lakehouses, and database engines except for Fabric & T-SQL products. This makes the usage of SQL templating engines unneces...Support external tables for parquet/csv in Fabric DW Fabric Data Warehouse allows reading Parquet and CSV files using the OPENROWSET function. However, it does not support external tables that reference Parquet or CSV files (CREATE EXTERNAL TABLE (Tran...
