Forum Discussion
Error with Filtering Field Parameter by using Slicer
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
Community SupportHi VenkatesuReddy ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.