Forum Discussion
Field Parameters - Returned using IF or Switch
Hi, I have a slicer which has a table of field parameters. I have a situation, that in a particular case, I want to show additional fields on the field parameter when a specific value is selected ( i...
Hi there, Good Day..
I tried this work around by adding a new column to field parameter and used the newly added column to my main table slicer.. this way I was able to control my Parameter values.
I tried this work around by adding a new column to field parameter and used the newly added column to my main table slicer.. this way I was able to control my Parameter values.
Just tried this and felt it worked for me, but I havent tested this extensively. your thoughts here is appreciated.
{ ("Customer", NAMEOF('DimCustomers'[NAME]), 0, "Table1"),
{ ("Customer", NAMEOF('DimCustomers'[NAME]), 0, "Table1"),
("Country", NAMEOF('DimCustomers'[COUNTRY]), 1, "Table1"),
("Sales Rep", NAMEOF('SalesPersons'[SALESMAN_NAME]), 2, "Table1"),
("Product Group", NAMEOF('ProductGroups'[Product Category]), 3, "Table1"),
("Customer", NAMEOF('DimCustomers'[NAME]), 0, "Table2"),
("Country", NAMEOF('DimCustomers'[COUNTRY]), 1, "Table2"),
("Sales Rep", NAMEOF('SalesPersons'[SALESMAN_NAME]), 2, "Table2")
}