Forum Discussion

Mokegubshook's avatar
Mokegubshook
Helper I
1 year ago
Solved

Dynamic Field Parameter base on another Parameter

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's avatar
    tharunkumarRTK
    1 year ago

    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!

2 Replies

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    1 year ago

    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!