Row Selection

[parthkwatra17]

Hi Guys, 

I am new to Power BI and want to design and automate a monthly portfolio report. 

I have downloaded an excel sheet containing the data and uploaded on Power BI.
I have filtered the columns I need from the excel sheet using the "Filter Column" tab. 

Q. How do I choose specific (red) rows that I need from the sheet and delete others?  Note: I need the entire row (Asset Tree + Market Value)

Looking forward to seeking your help! 

[v-jianpeng-msft]

Thank you lbendlin 

Hi, @parthkwatra17 

You can do this in the filter panel, here's a screenshot:

Result as follow:

Best Regards

Jianpeng Li

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

[lbendlin]

That data is not in a usable format. You need to transform it before youcan load it into Power BI.

Power BI is not Excel. Don't try to make it behave like Excel.

[parthkwatra17]

Hi, I know it's not excel and I am seeking assistance on transforming the data only. While I managed to "choose colums", I want assistance for choosing specific "rows" and run an automation. 

Please respond only if you can help! 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...