Forum Discussion
Error with Filtering Field Parameter by using Slicer
I have excel datasource and it contains only one table. In the trasformations I deleted the first row i.e( It contains 4 systems, they are Product, Category, Channel and Item), the next row I used ad a header. I have create field parameter based on the excel sheet. Later I considered all the columns from the table and I am using that Field parameter in the table visual.
My requirement is I need to create 4 buttons/slicer for those 4 systems (Product, Category, Channel and item), When I select each button of select in the slicer the related columns should filter in the Table visual where I am using Field Parameter
Here is the Sample Data. Please help me to solve this and Advance Thanks!
| Data Type | Applicable SSID | Product Name | API column name | Business Name | Element Name | Metric | Product API | Sequence | Transformations | Category Table Name | Category Column Name | Category Definition | Channel Column Name | Channel Folder | Item Table name | Item Column name |
| Fact | 219 | Product Sales new | Product_nbr | Store Number | Available | 24.7.0 July Release | 1 | store_nbr | day_fct | siteKey | Description | Store ID | Store>>Store Status and Stats | FVD | FVD | |
| Fact | 219 | Product Sales new | item_nbr | Item Number | Available | 24.7.0 July Release | 2 | item_nbr | day_fct | prod_key | Description | Product ID | Product >>Product Status and Stats | FVD | FVD | |
| Fact | 219 | Product Sales new | chnl_nm | Channel | Available | 24.7.0 July Release | 3 | svc | day_fct | promo_id | Description | Promo Id | Event>> | FVD | FVD |
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
5 Replies
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,
ChaithraHere is the clear sample data, Please help me to the above problem.
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.Hi 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.Hi VenkatesuReddy ,
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.
