Use options button to populate table in model

[Anonymous]

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"

[Anonymous · Accepted solution]

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.

[Anonymous]

Hi thank you for your help on this. I think I may not have been clear enough in my question. 

Is it possible to populate a column in a table in the model (not viz) based on slicer selection?

Many thanks

[Anonymous]

Hi @Anonymous ,

Based on my test, it will come out an error because the column can not recognize the selected value on a visual.

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.