Forum Discussion
Viewing and filtering only pre-determined data
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 , 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
2 Replies
- amitchandakSuper User
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
- AbbasGMemorable Member