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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
manuelfigueira
Helper II
Helper II

Auto fulfill Table (with blank rows in between)

Hello,

 

I'm trying to get this done and I'd like to have your opinion whether is possible or not?

 

I have this values (table 1) and I woud like to create a measure(s) where I can extract some values from the table 1 below and add it on to a new preformatted table (Table 2) on those yellow highligthed cells, however, the preformatted table got a blank row space inbetween the cells to be fullfilled. 

 

Many thanks!

 

 

 

Table 1

Table1.jpg

 

Table 2

Table2.jpg

1 ACCEPTED SOLUTION

Hi , @manuelfigueira 

I'm afraid it couldn't achieve in Power BI for now. For your requirement , you can come up with a new idea and add your comments there to make this feature coming sooner. 

https://ideas.powerbi.com/forums/265200-power-bi-ideas 

Best Regards,
Community Support Team _ Eason

View solution in original post

5 REPLIES 5
JirkaZ
Solution Specialist
Solution Specialist

@manuelfigueira What are you trying to achieve? It seems like an "Excel mindset" to me. Then I'd say don't try to make Power BI work like Excel because it's not Excel.

Hi @JirkaZ 

 

Thank you for your reply!

 

What I'm trying to achieve is fulfill the cell highlighted in yellow on the table 2 from the values on the table 1. Yeah, a little bit of Excel mindset but, I believe this can be done!

 

Thank you for your idea!

@manuelfigueira  I'd say you should just group 2 separate table visuals and arrange them in whatever way you like.

@JirkaZ and how to export to Excel those two tables in just one tab?

Hi , @manuelfigueira 

I'm afraid it couldn't achieve in Power BI for now. For your requirement , you can come up with a new idea and add your comments there to make this feature coming sooner. 

https://ideas.powerbi.com/forums/265200-power-bi-ideas 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.