Forum Discussion
Table with Blank Rows
Hi Everyone, Thank you in advance for your help. I'm farily new to Powerbi and had a question. I have a table where I need to have the blank rows be filled in with the main service listed ...
Hi Chipsahoy1 ,
You can follow steps to get your desired output:-
1. Go to trasform data tab, select your Modality,subtype and construct column and right click on it then select replace value option shown below:-
2. Now put one space in "value to find" and add null in "Replace with"
3. Now on the top ribbon click on "Fill" and select "Down"
Below would be the final output and now click on close and apply:-
Thank You,
Samarth