Forum Discussion
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
Community Champion
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
Community Champion
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
Helper I
What do you mean by: "and create a duplicated table of dimdate. "? shall I duplicate my original table?
- Daniel29195
Community Champion
if you do not have a dimdate table, and you are reading the date from your original table, then yes.
- AnonymousNot 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
Helper I
Hi Anonymous
I have not got a solution unfortunately.