Dynamic Field Parameter base on another Parameter

Mokegubshook — Sun, 27 Apr 2025 05:05:32 GMT

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:

Re: Dynamic Field Parameter base on another Parameter

tharunkumarRTK — Sun, 27 Apr 2025 05:46:37 GMT

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!

Re: Dynamic Field Parameter base on another Parameter

Mokegubshook — Sun, 27 Apr 2025 10:21:34 GMT

It's Work! Thank you

topic Re: Dynamic Field Parameter base on another Parameter in DAX Commands and Tips

Dynamic Field Parameter base on another Parameter

Re: Dynamic Field Parameter base on another Parameter

Re: Dynamic Field Parameter base on another Parameter