cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SushmaReddy
Helper I
Helper I

Hide a column based on another table column

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors