Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have heatmap basically that show what is the most apparent type of issue that our workers face. In 2023 it worked but now once I select the year to 2024. It shows nothing. Every formula should be the same and this is the only table that doesn't work with 2024.
I'm pretty stumped because this should be so simple that I can't even fathom what is going wrong from Point A to Point B.
Please see some relevant images and if you need anything more to troubleshoot, please let me know. Apologies for the blue lines but you will absolutely be able to tell something is different even without seeing the data.
EXPECTED OUTPUT: 2023, this works successfully.
HOWEVER: Just by changing the year to 2024, I get 0 data in either.
You can see that in the same table, it just uses some simple calculations to find out what is the Year, Month and Name and I should have data up til about May. The Table is called 'AtRiskComments'
Solved! Go to Solution.
Hi @Azaingod
Make sure your filter doesn't exclude specific data.
In my opinion, there is nothing wrong with the DAX you have shown so far, maybe the problem is with other measures.
If possible, please share your PBIX file so that we can help you better.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ah I did check the filters and I see the problem. There is a mysterious filter set to only look for August.
The original problem has been solved by just copy the tables to a new sheet.
However this is a picture of my filters and there should be nothing set to August.
When I hover it gives more information as 'Raw Entry List'[Month Name] however 'Raw Entry List' is not even used on this table. Do you have any idea where this August is coming from?
I will mark your as a solution because you telling me to checked the filters worked.
However, if anyone else runs into this problem. I fixed it by copy and paste all my tables to another page.
Hi @Azaingod
Make sure your filter doesn't exclude specific data.
In my opinion, there is nothing wrong with the DAX you have shown so far, maybe the problem is with other measures.
If possible, please share your PBIX file so that we can help you better.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |