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
