Forum Discussion
Information Display in a table
Hi All
Hope you guys can help
I have a code for the countries which I want to surface in a table in PBX.
However, when I choose to display it, it only displays values for Africa and Not for Oceania region despite tables being linked via countries list
The linkage looks as below:
"Global Location Ref" is used as a table Country on the image above (and all tables are linked via countries)
Any hel will be greatly appriciated
Hi Anonymous
first of all implenting a star schema with bi-directional filter is rarely a good idea. TO build a cleaner model you should merge ANZ and Africa table in Power Query upfront. There is a high probabily that also your challenge will be solved by that.
Best regards
Michael
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
3 Replies
Hi Anonymous
first of all implenting a star schema with bi-directional filter is rarely a good idea. TO build a cleaner model you should merge ANZ and Africa table in Power Query upfront. There is a high probabily that also your challenge will be solved by that.
Best regards
Michael
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Hi Anonymous ,
please first study the fundamental importance of a star schema data model.
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
You don´t need to use many to many relationships, instead only 1 to many relationships.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
