Forum Discussion
Pick column based upon user selection (Yes/No)
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.
2 Replies
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.
NathanielNathaniel_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
