Skip to main content
Microsoft Idea

Power BI

Under Review

Custom and Named Sets support

Vote (486) Share
Jen Underwood's profile image

Jen Underwood on 13 Nov 2014 00:55:15

Custom sets and named sets should be supported.

Administrator on 10 Jul 2020 16:04:37

Thanks for the suggestion! We'll consider it along with the others here and prioritize it based on the votes. If you want to help raise the priority, keep voting!

Comments (79)
Jen Underwood's profile image Profile Picture

Tej on 05 Jul 2020 22:43:14

RE: Custom and Named Sets support

I've created about 45 Named Sets in my SSAS cube only to discover that I can't use this in Power BI. For a product competing with other vendors like Tableau, this is definitely a big minus on Power BI.

Jen Underwood's profile image Profile Picture

Howard Taylor on 05 Jul 2020 22:42:10

RE: Custom and Named Sets support

Named sets enable users to control the views more dynamically and hence should be an out of the box feature to enable more flexibility. Filtering and ordering of members is too basic to achieve what you need from a dynamic changing environment where time does not stand still.

Jen Underwood's profile image Profile Picture

Amey on 05 Jul 2020 22:40:53

RE: Custom and Named Sets support

Need this feature on high priority.

Jen Underwood's profile image Profile Picture

Alex Whittles on 05 Jul 2020 22:37:32

RE: Custom and Named Sets support

Very important requirement - gets my vote

Jen Underwood's profile image Profile Picture

Kieran Wood on 05 Jul 2020 22:37:00

RE: Custom and Named Sets support

This is a key requirement since ..
A lot of Power BI customers are reluctant or unable to migrating there Multi dimensional cubes to Tabular Models.
So connecting to a named set, e.g. Top 10 Products within a SSAS MD Cube from Power BI is a frequent requirement.

Jen Underwood's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:36:44

RE: Custom and Named Sets support

Yes please. My company defines named sets in the cubes but these are not recognized in Power BI

Jen Underwood's profile image Profile Picture

C Thomsen on 05 Jul 2020 22:32:54

RE: Custom and Named Sets support

Named Set and Hierarchical Slicers seem like a must

Jen Underwood's profile image Profile Picture

Ted Stillwell on 05 Jul 2020 22:31:39

RE: Custom and Named Sets support

I strongly vote for this!

Jen Underwood's profile image Profile Picture

Muhammad Yasir Aleem on 05 Jul 2020 22:28:44

RE: Custom and Named Sets support

There is lot of stuff which is part of NamesSets so there should be support in PowerBI.

Jen Underwood's profile image Profile Picture

Aaron Shumaker on 05 Jul 2020 22:26:28

RE: Custom and Named Sets support

Common requirement for my users are dashboards/reports with rolling 3 months figures. This feature was closed for Excel, and PowerBI doesn't support either. https://connect.microsoft.com/SQLServer/feedback/details/619958/named-set-cannot-be-used-as-filter-when-browsing-a-cube-in-excel