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
nemo
Helper I
Helper I

Dynamically change the field in a table based on filter selection

Hi All,

I have these 2 tables in my PBI model

 

Table 1    Table 2
booktopic 1topic 2topic 3 topic
book 1aaa 1bbb 1  topic 1
book 2aaa 2 ccc 2 topic 2
book 3 bbb 3ccc 3 topic 3
book 4aaa 4bbb 4   
book 5aaa 5 ccc 5  

 

Is it posisible to use the column topic of Table 2 as a filter and depending on its selection, a correspoding columns (topic 1, topic 2 or topic 3) would be displayed in a table like this?

nemo_0-1664599064603.png

That is, if I selected topic 3 in the filter, the visual would look like this? 

nemo_1-1664599209753.png

Thank you in advance.

1 ACCEPTED SOLUTION
ddpl
Solution Sage
Solution Sage

@nemo ,

 

First you need to unpivot Table 1,

bin01.png

bin02.png

 

After that you can create a matrix and you can slice it as you requested...

 

bin03.pngbin04.png

View solution in original post

1 REPLY 1
ddpl
Solution Sage
Solution Sage

@nemo ,

 

First you need to unpivot Table 1,

bin01.png

bin02.png

 

After that you can create a matrix and you can slice it as you requested...

 

bin03.pngbin04.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.