Viewing and filtering only pre-determined data

[AbbasG]

Hello All,

I want to create a Power BI report for viewing and tracking the retail products. I have the data which consists of approx 25k+ rows.

But I want to view and track only 200 products in my BI report out of those 25k+.

I have created a master list of 200 products in excel. But I am stuck with filtering the raw data as per my need.

What will be the best way to achieve this? Any help will be appreciated 🙂

[AbbasG]

@amitchandak thank you for the quick response.

Let me try that!

[amitchandak · Accepted solution]

@AbbasG , Merge that in power BI with you product and create a flag and use that last page or report level filter

https://radacad.com/append-vs-merge-in-power-bi-and-power-query