Filter parameter table on other slicer

[Theo1403]

Hi,

I have a report with a table in it. One of the columns is a field parameter. The field parameter contains 2 columns (column 1 en column 2) from the dim_supplier table. The report also contains a slicer on another dimension table. If one option in the slicer is selected, column 1 should show in the table, if multiple options are selected, column 2 should show in the table. I am sure this can be achieved by a visual level filter on the table, but I have not been able to get the solution right.  Anyone already solved this problem?

Best regards,

Theo

[Praful_Potphode]

Hi @Theo1403 ,

Please try sample pbix.

if it doesnt work,please provide more information on output.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[DNMAF]

Hi @Theo1403 , if your only requirement is "If one option in the slicer is selected, column 1 should show in the table, if multiple options are selected, column 2 should show in the table." and you are fine with a fixed column name, the following measure should work as your dynamic column:

Dynamic Column =

    VAR _selected = SELECTEDVALUE(dim_other[Other], BLANK())

    VAR _selectedCol1 = SELECTEDVALUE(dim_supplier[Column1], BLANK())

    VAR _selectedCol2 = SELECTEDVALUE(dim_supplier[Column2], BLANK())

RETURN

    IF(ISBLANK(_selected), _selectedCol2, _selectedCol1)

Hope that helps!