Forum Discussion
Solved
Hiding column based on selection in table/matrix
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 ...
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.
