Forum Discussion
When creating a relationship between two table values not showing in matrix visual
Hello,
I really need urgent help on this one. As I am creating a relationship between multiple tables from Calendar Table which I created. I am not getting values in Matrix. Please review the below screenshot and details.
I am attaching the PBIX file and data file, please review and help
https://drive.google.com/drive/folders/1d-IYQB2oYOAF8zIpbXuabOAkwumsMO9J?usp=sharing
The below screenshot shows without any relationship between the date table and other tables which I have it gives the count however, it is giving the total count for the year and not by week i.e. Week 28 should 13 Count of CSat and Count of Column 8 should have 11
Now with the relationship, the other tables the values goes blank as shown below, even the weeks are not showing.
amitchandak AllisonKennedy Greg_Deckler ChrisMendoza Jihwan_Kim Please help out
Hi,
I am not 100% sure what you are trying to achieve, but please check the below comment and please try to fix your data model.
- In the fact table, I saw there are two columns describe date & time -> In the Power Query, change the data type to DATE type, not Date/Time type. If you need Time level analysis, create separate columns for time.
- Make sure that your calendar table is assigned as Date Table
-Relationship has to be properly created. I saw that Date column and CSAT column are connected. I think this is incorect.
Thanks.
9 Replies
saud968 , I doubt some matching data is missing or there is a filter on the page.
check data for two tables at a time. with help from this option check the missing values
amitchandak I have the slicer to select the quarter. Below are the screenshots of my tables I need to get count of column 8 and Column CSAT
Total Relation Ship between tables
Once I tried the above option you gave it now show week numbers however no data
I have also tried now to create a similar calendar week table in the other table, still the count is not showing up
Hi,
I am not 100% sure what you are trying to achieve, but please check the below comment and please try to fix your data model.
- In the fact table, I saw there are two columns describe date & time -> In the Power Query, change the data type to DATE type, not Date/Time type. If you need Time level analysis, create separate columns for time.
- Make sure that your calendar table is assigned as Date Table
-Relationship has to be properly created. I saw that Date column and CSAT column are connected. I think this is incorect.
Thanks.
Hi,
I could not find all the dimensions that are described in the screenshot.
Please share the complete sample pbix file, then I can try.
Thanks.
Jihwan_Kim Changing data type worked however it is showing incorrect I will work on it if I have any difficulty I will reach out ...Thank your Help
And Everyone else who assisted on this one.
