topic Re: Hide a column based on another table column in DAX Commands and Tips

Hide a column based on another table column

SushmaReddy — Mon, 26 Sep 2022 17:00:14 GMT

Hi Team,

I am using 2 sharepoint lists as source in the report and both lists contains Country as one of their columns, when the value of Country in 1st list is "TRUE" then the column 'country' in another list should be displayed in the table visual otherwise hide the column.

If it is achievable pls let me know the way to resolve it.

Thanks & Regards,

Sushma

Re: Hide a column based on another table column

amitchandak — Tue, 27 Sep 2022 02:08:41 GMT

SushmaReddy , You can make that blank. Create a measure like this and use that as a visual level filter of another slicer and check for value =1

int(calculate(isfiltered(Table[Column1]), allselected() ) )

refer video from Guyinacube

https://www.youtube.com/watch?v=sXn-QZqLD-8