Show and hide column based on value of another column.

[donghoonkim1226]

Hello!

I am running into a little issue.

I have a table with 3 columns. 

Column A - Boolean - True or False

Column B - Integer

Column C - Integer

I want to show Column B & Column C in the table only if Column A is equal to true. 

Can someone help me find a solution?

I am using the table visual.

Still very new to power bi.

Any help is greatly appreciated.

Thank you! 

[shebr]

Hi @donghoonkim1226

Do you mean you want to filter the table to only show 'True' values? If you hide the other two columns if its false then won't that table be blank? Can you elaborate a bit more, perhaps share some additional data that you're using?

Thanks

shebr

[donghoonkim1226]

Thank you for your response @shebr,

I will do my best to give you more details.

The report has a table with many columns as well as a visual slicer to help the user filter what they need and do not need. 

I have a visual slicer called Alternate Quote with a selectable value of False or True. 

When the user selects true, it will filter out the table to only show quotes that are Alternate Quotes (true).
There are 3 columns in the table that are associated with the Alternate Quote. See below.

Alternate Quote - Boolean

Pricing Quote - Integer

Pricing Quote Amount - Dollar Value

Now the issue I am having is, when the user selects False for Alternate Quote. I want to be able to hide Pricing Quote and Pricing Quote Amount columns from the table. Since they will just be empty with NULL values. 

[v-yuezhe-msft]

@donghoonkim1226,

It is not possible to hide columns in visual based on slicer selection, there is an idea about this issue, please vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19435267-conditional-visibility-o...

Regards,
Lydia

[donghoonkim1226]

thank you @v-yuezhe-msft for the information. The PowerBI improvement idea has been voted up!