Forum Discussion
Use options button to populate table in model
Is it possible to have an "options" button on the page (eg to say "Platform", "Business" or "Product")?
Use case:
Users choose a single option and this appears in the "Selection" column in a particular table/table query for each row
Example: users choose eg "Platform"
Then "Platform" appears for each row in the column called "Selection"
Hi Anonymous ,
Create a silcer and use SELECTEDVALUE() function might help you.Check following steps as below.
1# Create a table with column "options" include values "Platform", "Business" and "Product".
2# Use "options" column as slicer.
3# Create a measure as below
selection = SELECTEDVALUE('table'[options])4# Add the measure to the visul you need.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
Create a silcer and use SELECTEDVALUE() function might help you.Check following steps as below.
1# Create a table with column "options" include values "Platform", "Business" and "Product".
2# Use "options" column as slicer.
3# Create a measure as below
selection = SELECTEDVALUE('table'[options])4# Add the measure to the visul you need.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.