Dynamic Field Parameter base on another Parameter

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!