Forum Discussion
Getting an issue with a Table Visual, blank rows
Hi,MFelix ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,SPa .I am glad to help you.
I'll try to reproduce what you need.
This is my test data.
The relationship:
However, since there is no relationship between the two Dim tables for filtering, they must create new fields (rows) if they place the same field into the Matrix/Table, there is a many-to-one relationship between them only with the ‘FACT Sub’ table, and there must be aggregate columns in the table visual or Power BI can't both be presented in a visual at the same time.
Power BI filters based on the relationship in the model, where the system recognises the [Name] column in both DIM tables as two fields that are not related at all (even though the only actual difference between them is that the table names don't match)
So I think Mfelix made a very good suggestion.
If your DIM Table 1 and DIM Table 2 have exactly the same fields between them, with only differences before the data, you can merge them into one table
create relationship
Display the filtered data through the created relationships.
Here is the result.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
Hi and huge thanks for taking the time to reply.
The Dim tables represent different types of individual. Lets say for example Sales and Engineers.
Therefore I require a table visual to be used that would display:
Table Columns:
Case Nr
Sales Name
Engineer Name
In example Data, lets say Peter and David relate to the same Case Nr. They would then be in the same row. I cannot use a matrix visual to achieve this as displayed in your examples, i need to use a table visual.
Once again, I would like to thank you for taking the time to respond to this query!
(wishing you all a great end to the year!)
