Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Everyone,
I have a issue in showing today to next 6 months of data using relative filter by using end date column only. In that I sum of the totals based on end date month I used +0 also to show if the month is 0 it will show but not works for me exactly. I tried month in hirearchy that shows all the month names i dont want to see all the month i want to see today to next months only
This is the measure for sum
Advance thanks to all,
Solved! Go to Solution.
Hi @Anonymous ,
Has your problem be solved?
Best Regards,
Jay
Hi @Anonymous ,
Try "show items with no data" feature.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Has your problem be solved?
Best Regards,
Jay
Hi @v-jayw-msft ,
My issue is not solved I am still stuck on that. Kindly help me on that issue.
Thank you
Hi,
Check in the formatting tab X Axis Section where "Type" should be "Continuous" instated of "Categorical".
Thank You,
Regards,
Venkata Nalla
Thanks for your reply. I tried to change categorical to continuous but I am not able to change it shows categorical only.
Thanks and regards,
Poornalingam
Hi,
I believe you taken Month names in "Date format" into the axis. Ex: Instead of "April", "4/1/2020" and format to month name.
Thank You,
Regards,
Venkata Nalla
Hi @nvprasad ,
I tried month name also that shows the single month name only if others months have no value it should display 0.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
76 | |
74 | |
55 | |
45 |
User | Count |
---|---|
117 | |
106 | |
77 | |
66 | |
65 |