Forum Discussion

Shota_Xuc's avatar
Shota_Xuc
Icon for Helper I rankHelper I
2 years ago

Separate rows with different walues with empty row

How can I separate rows with different dates in column "Valuation date" in below visual?

 

I need something like that:

Is it possible in Power BI?

 

14 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion

    Shota_Xuc 

     

     

    one approach you can use, is matrix ,

    output 

     

    in the row total, turnoff the totals until you have the space you want .

     

     

    then, for text total, change to space 

     

     

    lastly, select all, then change color to white or to the table background .

     

     

    let me know if this helps .

     

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up πŸ‘ and mark it as the solution βœ…
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🀠

     

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion

    Shota_Xuc 

    another approach

     

     

    go to power query.  and create a duplicated table of dimdate. ,

    and thn add column --> ""

     

     

    step 3 : 

    change colum name to a column name of your real table ( example, Name ) 

     

     

    now, go to your first table ( real table ) , and append it with the newly created table ,

     

    you will have the following table : 

     

     

    now apply and close, 

     

     

    go to power bi , drag and drop your columns to the table visual .

     

    leave it empty , and select color =  color of background ( white ) 

     

    click done . 

     

     

     

    this should work .

     

     

     

    let me know if this helps .

     

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up πŸ‘ and mark it as the solution βœ…
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🀠

     

     

    • Shota_Xuc's avatar
      Shota_Xuc
      Icon for Helper I rankHelper I

      Daniel29195 

      What do you mean by: "and create a duplicated table of dimdate. "? shall I duplicate my original table? 

      • Daniel29195's avatar
        Daniel29195
        Icon for Community Champion rankCommunity Champion

        Shota_Xuc 

        if you do not have a dimdate table,  and you are reading the date from your original table, then yes.

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Shota_Xuc 

     

    It seems that you have gotten a solution. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

     

    Best Regards    

    Zhengdong Xu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • Shota_Xuc's avatar
      Shota_Xuc
      Icon for Helper I rankHelper I

      Hi Anonymous 

       

      I have not got a solution unfortunately.