Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table that looks similar to the following data:
Name, Order_ID, Items_1_Name, Items_1_Quantity, Items_2_Name, Items_2_Quantity, Items_3_Name, Items_3_Quantity, Items_4_Name, Items_4_Quantity
Some rows will have blanks for some of the items columns depending on if the order has more than 1 type of item, and the same item can be in different columns. I'd like to create a filter that scans each of the Items_Name columns and filters on the item, so it only returns the items selected instead of needing to create 4 different filters to filter the same value. How can I do this?
Solved! Go to Solution.
To create a filter that scans each of the Items_Name columns and filters on the item, you can use Power BI’s built-in features. Let’s break down the steps:
Unpivot Columns:
Create a New Column:
Create a Slicer:
Apply the Filter:
Result:
Hi @b_steward_2024,
Assuming I understood your requirements correctly, I believe you require a Master Item List that can be used to filter your existing tables. We can achieve this using the following steps -
Taking the below sample dataset as an example
Once the transformations are applied and tables are available for building visuals, complete the below steps -
Filtering examples
Let me know if this helps or if you have any other requirements!
Hi @b_steward_2024,
Assuming I understood your requirements correctly, I believe you require a Master Item List that can be used to filter your existing tables. We can achieve this using the following steps -
Taking the below sample dataset as an example
Once the transformations are applied and tables are available for building visuals, complete the below steps -
Filtering examples
Let me know if this helps or if you have any other requirements!
Thanks for the in depth answer, this was exctly what I was looking for. Very helpeful and useful 😄
To create a filter that scans each of the Items_Name columns and filters on the item, you can use Power BI’s built-in features. Let’s break down the steps:
Unpivot Columns:
Create a New Column:
Create a Slicer:
Apply the Filter:
Result:
Thanks for the answer, this was also extremely helpful
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |