Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
When I create table that shows both unit_name and unit_type_id from tables 1 and 3 everything works.
When I create table that shows both unit_id and unit_type_id from tables 5 and 3 again - everything works.
But when I try to show all of that columns in one table I get error "Can't display visual". Details say there is no connection in model, but as you can see ther are.
Table number 2 just connects 1 and 3.
Table 4 filters only one name of types on all pages.
Solved! Go to Solution.
Hi,
I tried your solution and it didn't work but I had to rebuilt my model anyway. I think the problem was solved once I joined tables into one bigger so probably something was wrong with the relationships as you say.
Hi @Anonymous ,
It seems like your fields not mapping correctly when you use all fields in the same visual. According to your snapshot, I found some tables are linked with single-mode relationships.
I'd like to suggest you change them to double-mode or remove these single-mode table fields to confirm if this issue related to them.
What is the Direction of Relationship in Power BI?
Regards,
Xiaoxin Sheng
Hi,
I tried your solution and it didn't work but I had to rebuilt my model anyway. I think the problem was solved once I joined tables into one bigger so probably something was wrong with the relationships as you say.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |