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.
Hi all,
Any idea why the YTD Revenue is blank for January and February?
Thank you very much.
Best regards,
Sya
Solved! Go to Solution.
Hi,
I think the reason is because your Calendar table has two Januarys and two Februarys.
I suggest putting a year column into the visualization might solve the issue.
Or, you can also create Year-Month column in order not to make any confusion.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
can you share your sample pbix file's link here?
And then I can try to have a look into it to find out the cause.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim ,
PBI:
https://1drv.ms/u/s!AjXpGcOFDGB2iFiLzHJzUnx8F9yk?e=8c4M9f
excel:
https://1drv.ms/x/s!AjXpGcOFDGB2iFnCFPPFJUA7dAlh?e=s4Epw9
Let me know if there's issue to access the files.
Thanks a lot!
Sya
Hi,
I think the reason is because your Calendar table has two Januarys and two Februarys.
I suggest putting a year column into the visualization might solve the issue.
Or, you can also create Year-Month column in order not to make any confusion.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |