Forum Discussion
Show different columns columns based on filter.
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?
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
1 Reply
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