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 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.
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 |
---|---|
109 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |