Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to Solution.
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
|
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
|
It's Work! Thank you
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |