Hiding column based on selection in table/matrix

[marslnn]

Hi,

I have slicer which has some kpi's in it. Lets say i have kpiA, kpiB and kpiC on slicer. When i select kpiC on my slicer, i want YTD column on my table/matrix to be hidden. Is there a way to achieve this simple requirement in PowerBI?

Thanks in advance.

[v-stephen-msft · Accepted solution]

Hi @marslnn ,

You could create a measure as a visual level filter.

Measure = IF(SELECTEDVALUE('Table'[kpi])="kpiC",1)

Then put the measure into the Filters on the visual. Set show items when the value is not 1.

Result:

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @marslnn ,

can you post an example file?

In Power BI it depends so much on the data model. Otherwise I can just assume and propose some approaches that might not work for you.

But in general hat is possible.

Best regards

Denis