Forum Discussion
Error with Filtering Field Parameter by using Slicer
- 1 year ago
Hi VenkatesuReddy ,
Thank you for posting in Microsoft Community.Create a Field parameter by new parameter in modeling pane where add all the columns from the Excel table after cleaning the headers into this Field Parameter.
Then create a supporting Table for systems which will let you filter based on "Product", "Category", etc.
In order to tell Power BI which fields belong to which system, create a mapping table for Field Parameter to System and join mapping table to Field parameter table. Now you can use a slicer to filter the table.
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Regards,
Chaithra
Here is the clear sample data, Please help me to the above problem.