Pick column based upon user selection (Yes/No)

[Anonymous]

I have 2 columns in a [table A] (ID, ID_Masked). Our need is, If user selects "Yes", then "ID_Masked" field needs to be displayed in the visual. If user selects "No", then "ID" field needs to be displayed. 

For user input we used "Yes/No" slicer, it's from an independent/dummy table which has no relationship with the main [table A]. 

FYI, There are 25 million data in [table A] and infact [table A] is a view which inturn uses/joins multiple underlying tables. And it will be growing day by day. 

BTW, Our report has multiple Yes/No filter/user input like this, that has a similar pair of columns/fields in the view definition. So we are looking out for option other than un-pivot/replicating the data for the various combinations of each filter in the view. Since that would make the data grows exponentially. Pls help us out. 

[Nathaniel_C]

Hi @Anonymous ,

Since the yes/no is a dummy, why not create two buttons, and two bookmarks? Two tables that turn on and off, and are right over each other.  When yes is selected, you get the ID masked table, and when no is selected, you get the ID table.

Please let me know if you have any questions. You will need to turn on the bookmarks pane, and the selection pane. Add the bookmark to the action on the button.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

@Nathaniel_C Thank you for the response. We have already checked on Bookmarks, but our need is to support multiple Yes/No filters on the same report. The current report has 3 filters and the combinations are below,

Filter 1	Filter 2	Filter 3
No	No	No
No	Yes	No
No	No	Yes
No	Yes	Yes
Yes	No	No
Yes	Yes	No
Yes	No	Yes
Yes	Yes	Yes

It will be great, if we get any solution for this scenario.

Regards,

@Anonymous