Error with Filtering Field Parameter by using Slicer

[VenkatesuReddy]

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

[v-echaithra]

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.

[v-echaithra]

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.

[v-echaithra]

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.

[v-echaithra · Accepted solution]

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

[VenkatesuReddy]

Here is the clear sample data, Please help me to the above problem.