Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

Relate Horizontal Columns with List

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

DayBasin ABasin BBasin C

3/1/20

146
3/2/20324
3/3/20543
3/4/20216

 

 

Table 2

Basins
Basin A
Basin B
Basin C
1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

I couldn't have said it better myself!

bchager6
Super User
Super User

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

bchager6_0-1631132201160.png

 




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.