Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a list of time-stepped data and I'm trying to create a slicer so that I can filter the data without having to drag and drop it each time. I can't think of a way to create a relationship without having to create a singular relationship for each field? Example Below:
Table 1
Day | Basin A | Basin B | Basin C |
3/1/20 | 1 | 4 | 6 |
3/2/20 | 3 | 2 | 4 |
3/3/20 | 5 | 4 | 3 |
3/4/20 | 2 | 1 | 6 |
Table 2
Basins |
Basin A |
Basin B |
Basin C |
Solved! Go to Solution.
Hi,
In the Query Editor, right click on the first column on Table1 and select "Unpivot other columns". Now create a relationship (Many to One and Single) between Table2 and the Attribute column of Table1.
Hope this helps.
Hi,
In the Query Editor, right click on the first column on Table1 and select "Unpivot other columns". Now create a relationship (Many to One and Single) between Table2 and the Attribute column of Table1.
Hope this helps.
worked great, I had over 20 basins, but was able to select them all and unpivot at the same time, thank you so much!
You are welcome.
I couldn't have said it better myself!
I would denormalize Table 1 if possible (unpivot the Basin A, Basin B, and Basin C columns), then connect the two tables via a 1:n relationship on Basin.
Denormalized Table 1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |