Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community,
Kindly help diagnose & rectify this issue wherein even if i slice my data for Calendar Year 2019 as shown by Period slicer i the image below- a card "Days in Period" which uses "Calendar table" still shows 1826 days- it should show 365 but not necessarily match with "Travel Days" card as that is coming from another table. I was able to rectify it by changing filter direction to both in the relationship tab between 2 tables. But, later that seemed incorrect as then both the slicers showed same results irrespective of my selection of destination country.
Why is the table "Calendar" not being cross-filtered upon slicer selection? Please help!
File attached too! https://drive.google.com/file/d/1I13Nukw13AYgnbtOpLxYq86-HX5tDQUq/view?usp=sharing
Thanks in advance
Solved! Go to Solution.
You just need to use the Date column from your Calendar table in your date slicer instead. The date table filter the other table but not the other way around. Slicing on the Period dates doesn't filter the Calendar table.
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.
You just need to use the Date column from your Calendar table in your date slicer instead. The date table filter the other table but not the other way around. Slicing on the Period dates doesn't filter the Calendar table.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |