Auto fulfill Table (with blank rows in between)

[manuelfigueira]

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

Table 2

[JirkaZ]

@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.

[manuelfigueira]

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!

[JirkaZ]

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

[manuelfigueira]

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

[v-easonf-msft · 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