Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a date table which i have joined with my fact table. I am using trying to use year month field as a slicer which i created in the date table, however when the slicer does not work when i select any value other than blank. can someone please help in isolating what going on here ? secondly why is blank value even coming up when i am using it in slicer , i checked the date table is not missing any date. i have tried to recreate the tables as well and it didnt work.
Hi,
Please check your repaltionship direction is both instead of single.
Best Regards,
Giotto
Hi,
@v-gizhi-msft It was single then i changed it to both however the issue remains.
@Greg_Deckler good one 😄
@v-gizhi-msft can someone from microsoft help me here, i am sure this is a very common scenario.
Hi,
Could you please share your file by OneDrive for Business?
Remember to move any sensitive data.
This will let me help you further.
Best Regards,
Giotto
The blank row shows up when there is at least one unmatched value in the fact table. In your case, it seems like none of them are matched. I would check for a type mismatch between the two tables. Is one a DateTime instead of Date?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi,
both fields are datetime.
Blanks in slicers means that there are rows in a relationship that are non-matching. Sounds like your relationship is messed up. Not that I am one to talk, I've been divorced twice! So, you know, not judging... 🙂
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |