Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Everyone.
I hope you're doing well.
I need your help.
I need to create a clustered column chart that should show the number of vacant and leased units every month during the number of years.
The sum of two columns in the chart should give the total number of units, but that doesn't work, because the database makes a record of units just when the status changes.
So, I need a function to generate rows automatically every month for every unit to keep copying the last unit status that comes from the database.
Are there any kind of functions or other solutions or ideas to get the same result?
Thanks in advance for your help.
Regards.
Abdullah Maher.
Hi, @Abdullah-Maher
Could you please provide some sample data on your question, be careful not to include private data.
Best Regards
Jianpeng Li
Hello @v-jianpeng-msft
I hope you're doing well.
Thank you for your cares.
I hope that helps.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |