Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Abdullah-Maher
New Member

Generated Conditional Row Automatically

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.

9fcb06af-ab7d-46d8-b7e3-8ef0de8fefe9.png

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.

2 REPLIES 2
v-jianpeng-msft
Community Support
Community Support

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.Screenshot (91).pngScreenshot (92).png

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.