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
danielPrieto
Advocate I
Advocate I

Show different columns columns based on filter.

We have a star model with bridge tables. Below is a part of the model:

modelExtendedFields.PNG

 

We have an user and course dimensions and the Evaluation Fact Table. Moreover, each client can set different properties on their users. Here is an example of each of these tables:

 

Property:

 

PropertyIDPropertyNameCustomerID
1Sex1
2Country1
3Year of Birth2
4Sex2

 

User:

 

UserIDPropertyIDPropertyValue
11M
12Spain
21F
22EEUU
31F
32France
431980
44F
531985
54M

 

Evaluation:

CourseUserScore
1190
2150
1280
4355
5315
545

 

We want to create a table visualization in which we can show to each customer (in the future each customer would be a role) the information of the evaluations of their students along with the information of their properties. For customer 1 it would have to show:

 

CourseUserScoreSexCountry
1190MSpain
2150MSpain
1280F

EEUU

 

However, for client 2 it should show:

CourseUserScoreSexYear of Birth
4355F1980
5315F1980
545M1985

 

There are many clients and I do not know the properties that all of them have created, so we should build the table dynamically.

 

Is there any way to do this in powerbi?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @danielPrieto,

 

It is impossible to create dynamic tables based on filter/slicer.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @danielPrieto,

 

It is impossible to create dynamic tables based on filter/slicer.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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.