Dynamic Field Parameter base on another Parameter

[Mokegubshook]

Hello, I want to show some value on slicer base on another slicer. My slicer View By and Status are made from field Parameter.

When I select

View By: Supplier --> Show Only Status by Supplier and Complete by Supplier 

View By: Files --> Show Only Status by File and Complete by File 

View By:

View By Status:

[tharunkumarRTK · Accepted solution]

@Mokegubshook 

From what I understand, you want the values of second slicer (Status slicer) to be dependent on first slicer (View by slicer). If yes then follow these steps

1. create a new column in second field parameter table, put the column name as "View By"

2. You can create this column either by modifying the dax expression of the table i.e add 4 value in each row likw below 

{
("Status by File", NAMEOF('EJV' [status by File]), 0, "File""), 
("Status by Supplier", NAMEOF('EJV' [status by supplier]), 1, "Supplier""),
("Complete by Supplier", NAMEOF('EJV' [completenes by supplier]), 2,"Supplier""), 
("Complete by File", NAMEOF('EJV' [Completeness by File]), 3,"File")
}

Or by creating a new conditional column. 

3. Link these two tables, View by table and Supplier table with a relationship (Viewby[Viewby] -> Supplier[Viewby]) 

4. Thats it

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[Mokegubshook]

It's Work! Thank you