Dynamic column based on slicer selection of a column in the same table power bi

[shjuanpark]

Hi I am trying to create a power bi report with a list in a sharepoint.

The list consists of 26 columns for example; A-Z.  Column Z has a yes and no values and based on Column Z value selected by slicer, I want to show different columns.

So in the power bi report, when nothing is selected,

A B C D E ...J

When Yes is selected by slicer, which is a column from the same table, i want to show

K L M N

I have only one dataset available in the power bi which is directly connected to shaerpoint list.  is there an idea to do so?

[Anonymous]

This can be achieved by data modeling.
Change the relationship direction from single to Both it will work.

[shjuanpark]

Thank you for your answer.  But it is not very clear for me to understand.  Can you ellaborate a little more about how to do so?  it will be very appreciated.

[Anonymous]

Refer to the below Screenshot.

[shjuanpark]

Thank you for your answer.  I wanted to remove some of the columns in the table and show different columns when a slicer is selected.  I might be doing wrong, but switching views by bookmark seems a possible alternative.  Thank you very much though!

[Ritaf1983]

Glad to help 😊

[shjuanpark]

@Ritaf1983 The table I have is like below.

I want to have slicer with Critical Column and when No is selected, i want to show 

Machine#, Progress, Critical, Committed Finish Date, Estimated Finish Date.

And when Yes is selected in the slicer, i want to show Machine #, Delay Hours, Latest Status, Detailed Status Columns of machine A and C.

Can you please take a look and provide me with an insight?

Machine#	Progress	Critical	Committed Finish Date	Estimated Finish Date	Delay Hours	Latest Status	Detailed Status
A	Wrapup	Yes	8/21/2023	8/25/2023	50	Test C ran	Test A ran Test B ran
B	Performance Check	No	8/21/2023	8/21/2023	-	-	-
C	Adjustment	Yes	8/31/2023	9/30/2023	100	Plan C done, wait for result	Plan A done Plan B done

[Ritaf1983 · Accepted solution]

Hi @shjuanpark 

If I understood you correctly and you are talking about conditional hiding columns, unfortunately this functionality is unavailable.
Here are some ideas about this issue you can vote for them :

https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=hide%20matrix%20columns%20&forum=2d80fd4a-1...

As an alternative, you can use bookmarks.
Add a button for your selection, prepare 2 matrixes, and switch between them.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983]

Hi @shjuanpark 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523