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.
i everybody,
I'm currently working on a report involving timeregistration, which involves files with entries for time off measured in hours. I display these in a matrix, and have three slicers (year, month, employee name). My problem is that while the matrix total show the correct amount of hours, they are not displayed in the matrix fields. Here's an example: this employee has 16h off in August of this year, which the total shows. When I access the records for the total, it shows two entries for the 17th and 31st.
I don't have any measures, and as far as I know no other filters that could prevent the values from being displayed (if they were filtered, they wouldn't be counted towards the total, right?)
Solved! Go to Solution.
Hi @Anonymous,
Please check out the file in the attachment. I have made some changes. Now you will have a model with best practices. I will check more to find out why. Please follow my adjustments for now.
1. Create a new table.
FullNames = DISTINCT ( UNION ( VALUES ( Timesheets[Full name] ), VALUES ( Vakantiedagen[Full name] ) ) )
2. Delete the *:* relationship and create new ones.
3. Use the new column from the new table in a slicer instead.
One tip: Don't upload sensitive data here.
Best Regards,
Dale
Hi @Anonymous,
Please share the file or a dummy one which can reproduce the issue. Just see from your information here, that's impossible. We need to check the data and its structure of the model.
Best Regards,
Dale
Hello Dale,
I added a link to the file in my post. Thanks in advance for looking, this is driving me absolutely cray-zee.
Hi @Anonymous,
Please check out the file in the attachment. I have made some changes. Now you will have a model with best practices. I will check more to find out why. Please follow my adjustments for now.
1. Create a new table.
FullNames = DISTINCT ( UNION ( VALUES ( Timesheets[Full name] ), VALUES ( Vakantiedagen[Full name] ) ) )
2. Delete the *:* relationship and create new ones.
3. Use the new column from the new table in a slicer instead.
One tip: Don't upload sensitive data here.
Best Regards,
Dale
Thanks for the information. I removed the PI in there, but have removed the uploaded file as well. You can remove your attached file. Again, thanks!
I'm glad it helped. It's my pleasure. @Anonymous. The file was deleted. You can send the link through Message next time.
Best Regards,
Dale
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |