Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs 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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@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.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@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
@saud968 Try making the cross filter direction Both for your relationships and see what happens.
@Greg_Deckler I tried still blank....though if I am selecting a blank option on slicer then I am getting the count. It might little incorrect but I can work through it, however, when I am selecting q3 for 2021 it goes blank
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |