Forum Discussion
Row Selection
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!
4 Replies
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.
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!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-Forum/ba-p/963216
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/1447523
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.
