Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Shota_Xuc
Helper I
Helper I

Separate rows with different walues with empty row

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

Shota_Xuc_0-1708607246990.png

 

I need something like that:

Shota_Xuc_1-1708607316174.png

Is it possible in Power BI?

 

14 REPLIES 14
v-zhengdxu-msft
Community Support
Community Support

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

Hi @v-zhengdxu-msft 

 

I have not got a solution unfortunately.

Daniel29195
Super User
Super User

@Shota_Xuc 

Daniel29195_4-1708633278189.png

another approach

 

 

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

Daniel29195_5-1708633305163.png

and thn add column --> ""

Daniel29195_0-1708633821289.png

 

 

step 3 : 

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

Daniel29195_7-1708633445308.png

 

 

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

Daniel29195_8-1708633499479.png

 

you will have the following table : 

Daniel29195_9-1708633531596.png

 

 

now apply and close, 

 

 

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

Daniel29195_10-1708633615023.png

 

Daniel29195_11-1708633637380.png

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

 

click done . 

 

 

 

this should work .

Daniel29195_12-1708633682123.png

 

 

 

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 

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

@Shota_Xuc 

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

 

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

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

 

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

@Daniel29195 

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

@Shota_Xuc  

yes . 

 

@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 = ""

 

@Daniel29195 

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

Shota_Xuc_0-1708701639085.png

 

Daniel29195
Super User
Super User

@Shota_Xuc 

 

 

one approach you can use, is matrix ,

output 

Daniel29195_0-1708632839227.png

Daniel29195_1-1708632862108.png

 

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

 

 

then, for text total, change to space 

Daniel29195_2-1708632913283.png

 

 

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

Daniel29195_3-1708632939274.png

 

 

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors