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 have a report where i display last registered sales date per product. Only issue is that when i have datefilters on the sales dates gets filtered aswell showing incorrect dates.
Does anyone have any advice on how to bypass the date slicer and show the corrected date?
Br,
Johannes
Solved! Go to Solution.
Hi @tex628,
The solutions depend on your data model. If you use a measure to get the last registered date, you could add one part "ALL('TABLE'[sales date])". Or you can use "Edit interaction".
Best Regards,
Dale
Hi @tex628,
The solutions depend on your data model. If you use a measure to get the last registered date, you could add one part "ALL('TABLE'[sales date])". Or you can use "Edit interaction".
Best Regards,
Dale
The table included many other columns that needed to be affected by the slicer so and to my knowledge there is no way to have the slicer interact only with a specific column using edit interactions. Either way i managed to work out a dax forumla using the allselected() function so it worked out in the end! 🙂
Br,
Johannes
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 |
---|---|
115 | |
100 | |
90 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |