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
Hi VenkatesuReddy ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.