Currently we can use Power Query menu options to do lots of things in PBI Desktop without having to know M Code. This has been a huge help in advancing the popularity of PBI Desktop. My suggestion is to expand this ability to nested tables. After performing a Nested Join or Group By, many times you end up with a Table Column that you need to add a field to like an index, or filter it to a max value, or several other things BEFORE expanding the column. The M Code to do these operations is not as straight forward and finding books on the subject are not readily available. My thought is you click in the first cell to show the full table in the window below the parent table, and then the menu option's "focus" switches to the child table allowing you to add columns, filter columns, do all the same stuff. When you close the child table view, the menu options then operate back on the parent table as they do today.
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Slicer option to show no data when no value is selected
Hello Power BI Team, Description: Currently, when the "Select All" option is enabled in a slicer, selecting it displays all related values as expected. However, when "Select All" is de-selected and...7407541 hour agoNew MemberNew2Views0likes0CommentsParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v2 hours agoCommunity ChampionNew10Views1like0CommentsAutomatically match PowerBI chart background color to Powerpoint slide background color
Export PowerBI to PowerPoint slide - Can we define the PowerBI export background color to automatically match the PowerPoint slide background color ? By Default, the PowerBI background color is Whi...jim_chan7 hours agoNew MemberNew7Views0likes0CommentsNew Card Visual - Alignment of Reference Label Values
The latest Power BI Desktop version I'm allowed to use at work currently is Version 2.154.1260.0 (May 2026), so if this request has already been implemented in later versions, please disregard. Othe...nk685f7 hours agoAdvocate INew9Views0likes0Comments