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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors