Forum Discussion
Problem with 3 data tables in a table chart
Use column of table A as slicer and put the columns of Table B and C in a table visual. You can start your analysis from this point. You cannot put all A, B and C in a single visual.
Thank you.
You are right but I would be fine with a cartesian product.
Because there are no money values and it is just about Dataquality.
I am only analysing if a employee has a country, working contract, hour rate etc filled in the DWH.
And the table is just to verify the data and to see if there is "null" value and in which column and for which employee it is. I don't care if Power BI duplicates the data because it is not for analyzing it.
Is there an option in Power BI to see all the values?
Use column of table A as slicer and put the columns of Table B and C in a table visual. You can start your analysis from this point. You cannot put all A, B and C in a single visual.
Would this also work with more tables?
They are all connected to table A.
So I can put tables B-H in the visual and use A as a slice?
Do I understand it right. Table B and C would be in the same table visual?It should work i guess. Try it once and let me know the result