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.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |