Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community,
I have built a Calculated table with a daily budget per date, shop, and continent with a CrossJoin of my Calendar table and my budget table (where budgets are monthly).
When I build my dashboard to display my budget to date per shop per date, I have blank values when there were no transactions in a specific date in my fact (Sales table).
Any ideas how to avoid that?
Thanks !
Solved! Go to Solution.
Hi @v-rzhou-msft ,
I have tried your tips, but it doesn't help. Thanks anyway for the reply.
However, I could find the issue by myself.
My Budget to date formula was missing : "all(_Calendar)"
Hi @v-rzhou-msft ,
I have tried your tips, but it doesn't help. Thanks anyway for the reply.
However, I could find the issue by myself.
My Budget to date formula was missing : "all(_Calendar)"
Hi @Pline_69 ,
Please make sure whether you have turn on "Show items with no data" in your field.
On myside, I create a sample to have a test. Data table contains data from 6/25/2023 to 6/30/2023 without 6/26/2023 and 6/29/2023. And it is connect to calendar table.
It won't show blank if I turn off this function.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |