Separate rows with different walues with empty row

[Shota_Xuc]

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?

[v-zhengdxu-msft]

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]

Hi @v-zhengdxu-msft 

I have not got a solution unfortunately.

[Daniel29195]

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

@Daniel29195 

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

[Daniel29195]

@Shota_Xuc 

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

[Shota_Xuc]

@Daniel29195 

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

If I duplcate my own table and append it to my original table, which columns shall I drag and drop to the visual? all columns which I use in my visual?

[Daniel29195]

@Shota_Xuc 

when you duplicate your table in power query, 

you need to remove all the columns except date  column  ( in your case valuation date ),

then you continue the steps mentioned ( as adding new column with empty value ) 

if you still facing issue, feel free to send the file in private , i would be happy to help you out . 

[Shota_Xuc]

I would be grateful if you can fix it, where shall I send the file? e-mail?

[Shota_Xuc]

@Daniel29195 

which column shall i apply conditional formating to? Valuation date?

[Daniel29195]

@Shota_Xuc  

yes . 

[Daniel29195]

@Shota_Xuc 

if everythin is done , then you should notice that you have now the data with blank values for all other rows. 

so you just need to change the color of evaluation date base on condition . that text = ""

[Shota_Xuc]

@Daniel29195 

I have done everyting but it does not work, nothing happens.

[Shota_Xuc]

[Daniel29195]

@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! 🤠