I would love to be able to make relationships between tables by two columns.
For a simple example being able to make a relationship between Year and Month between two tables. This would allow it to be a one to many or one to one relationship rather than creating whole new table through a merge to be able to do this.
*I know this is an easy work around with a date column but other key columns are not easily fixed in that sort of way.
It would be similar to joining two tables in SQL ON two columns.
table1.Year = table2.Year AND table1.Month = table2.Month
This would instead define the relationship between two tables in PowerBI.
Maybe be able to hit ctrl, select two columns and drag them to another table to build that relationship in a similar manner as a relationship is made right now.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Exported PDF from PowerBI to not have any indents/borders
Currently, using the "Export to PDF" option in PowerBI results in two consistently buggy results: A white border/indent is generated, increasing the size of the page from 8.5x11 to 9x11.5 Sometime...EliShalev2 hours agoNew MemberNew6Views0likes0CommentsAdding a Container for Logical Grouping of Activities in Data Pipelines
Dear Team, I would like to propose a feature enhancement for Data Pipelines in Microsoft Fabric that allows the logical grouping of activities into a container. This container would serve to: Im...lukas_karlovsky3 hours agoNew MemberPlanned870Views15likes5CommentsSupport Native SQL LIKE / NOT LIKE Wildcard Filtering Across Power BI Reports
Description Currently, Power BI does not provide a native way for report consumers to perform dynamic SQL-style wildcard filtering using patterns such as LIKE '____' - Above return all values wit...Seeralan4 hours agoNew MemberNew6Views0likes0Comments