Forum Discussion
Switch not working (only passing alternate value)
Super UserSorry for the additional questions but can you explain a little bit better what you need to achieve?
You want to limit the data that the users sees or do you want to have it dynamic?
Can you make some example please?
I'm wanting the 'dynamic column' to be dynamic - but it needs to be within the dataset - so that single item is useable throughout the rest of the report for that user (based on RLS).
Unfortunately - our IT setting prevent me uploading any data (veen non business related), so I put a small example in previous post.
essentially - I need to create a mechanism that either
• the RLS model determines the variant structure (type 1-3) or
• Operator selects this from a slicer to determine type 1, 2 or 3)
then with the result of that:-
.Populates type 1, 2 or 3 into the 'Dynamic column' ready to be used by other slicers and also for a fixed item on a report table for download.
So ... from the Data
| Column 1 | Column 2 | Column 3 |
| This Thing | That thing | Another Thing |
| Something | Everything | What Thing |
Option 1 would return
| Column 1 | Column 2 | Column 3 | Dynamic Col |
| This Thing | That Thing | Another Thing | This Thing |
| Something | everything | What Thing | Something |
Option 2 would return
| Column 1 | Column 2 | Column 3 | Dynamic Col |
| This Thing | That Thing | Another Thing | That Thing |
| Something | Everything | What Thing | Everything |
Option 3 would return
| Column 1 | Column 2 | Column 3 | Dynamic Col |
| This Thing | That Thing | Another Thing | Another Thing |
| Something | everything | What Thing | What Thing |
the key is that the data in the Dynamic Column would be a 'swap out' based on the option, rather than hiding the unused columns like a normal parameter action would result in
Hope that makes sense - and thanks so much for you help!