Forum Discussion

manuelfigueira's avatar
6 years ago
Solved

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

 

Table 2

5 Replies

  • JirkaZ's avatar
    JirkaZ
    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.

    • manuelfigueira's avatar
      manuelfigueira
      Helper II

      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's avatar
        JirkaZ
        Solution Specialist

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