Show different columns columns based on filter.

[danielPrieto]

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

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:

PropertyID	PropertyName	CustomerID
1	Sex	1
2	Country	1
3	Year of Birth	2
4	Sex	2

User:

UserID	PropertyID	PropertyValue
1	1	M
1	2	Spain
2	1	F
2	2	EEUU
3	1	F
3	2	France
4	3	1980
4	4	F
5	3	1985
5	4	M

Evaluation:

Course	User	Score
1	1	90
2	1	50
1	2	80
4	3	55
5	3	15
5	4	5

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:

Course	User	Score	Sex	Country
1	1	90	M	Spain
2	1	50	M	Spain
1	2	80	F	EEUU

However, for client 2 it should show:

Course	User	Score	Sex	Year of Birth
4	3	55	F	1980
5	3	15	F	1980
5	4	5	M	1985

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?

[Anonymous · Accepted solution]

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