Filter another filter with parameters

[esquiveljc]

Hi everyone,

I have a table with 4 cities with assigned numbers for each column: D, E, and F.  I also have another column with the maximum values ​​in D, E, and F for each city.

City       MaxDEF D     E         F

Miami	1	0	1	1
Boston	2	2	1	0
Chicago	3	3	2	1
Seattle	3	0	0	3

These numbers represent colors.

I put this in a map, and for the legend I created the following parameter:

Parameter = {
("MaxDEF", NAMEOF('Table'[MaxDEF]), 0),
("D", NAMEOF('Table'[D]), 1),
("E", NAMEOF('Table'[E]), 2),
("F", NAMEOF('Table'[F]), 3)
}

I put too these parameter in my FilterLevel1.

This works fine, but I want a second filter (FilterLevel2) to be able to choose the color numbers for each choice in my FilterLevel1. So to explain better, in my FilterLevel1 when I choose the MaxDEF option, my FilterLevel2 should display "1, 2, 3". When I select "D" in my FilterLevel1, it should display "0,2,3" in my FilterLevel2, and so on.

Do you have any idea how I can create FilterLevel2 knowing that a filter doesn't accept measure?

Thank you!

[amitchandak · Accepted solution]

@esquiveljc , Hope you are using this features

Create dynamic slicers using field parameters
https://powerbi.microsoft.com/en-za/blog/power-bi-november-2022-feature-summary/#post-21321-_Toc1175...

In this case, it will not keep the previous filter values when you change the value 1

refer if needed
Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-2025...