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.
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.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |