Hide a column based on another table column

[SushmaReddy]

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

[amitchandak · Accepted solution]

@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