Forum Discussion
Dynamic filter on visual with Field Parameters
Hey there,
is it possible to dinamically change filter on a visual with Field Parameters?
Measure shall stay the same, the only thing that shall change is the selection on a visual filter.
Thank you
gianmarco
Yes it is possible.
Create the field parameter. With this operation you would see appear a new table.
In this table create a new column (with the id) and connect it in the relationship you would to choose your value.
The table is rapresent like this:
Description
Fields
Order Fields
IdParametric Slicer = {("NameField1", NAMEOF('Table1'[Field1]), 0, "ID_01"),("NameField2", NAMEOF('Table2'[Field2]), 0, "ID_02"),("NameField1", NAMEOF('Table3'[Field3]), 0, "ID_03")}
If you want more support please upload the pbix file.
If i resolve your problem please mark it as a solution.
Ciao!
2 Replies
Yes it is possible.
Create the field parameter. With this operation you would see appear a new table.
In this table create a new column (with the id) and connect it in the relationship you would to choose your value.
The table is rapresent like this:
Description
Fields
Order Fields
IdParametric Slicer = {("NameField1", NAMEOF('Table1'[Field1]), 0, "ID_01"),("NameField2", NAMEOF('Table2'[Field2]), 0, "ID_02"),("NameField1", NAMEOF('Table3'[Field3]), 0, "ID_03")}
If you want more support please upload the pbix file.
If i resolve your problem please mark it as a solution.
Ciao!If i resolve your problem please mark it as a solution.