Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Extracting values from a slicer

Hi,
I am in the process of converting a Dashboard that I made in R - Flexible Dashboard to PowerBI. I am trying to mimick the 'Reactive' feature of R Shiny in PowerBI. So far, I have been able to create some slicers that can subset a value table appropriately. However, since dynamic table capture does not seem to be a PowerBI feature yet, I have had to resort to alternative means to work around this issue. I am attempting to capture the values selected by the user in each of the slicers and populate a table that changes each times the slicer values change. My intention is to use this slicer value table as an input parameter in a R script, along with my main table, and then do the appropriate subsetting of the main table inside the R script. 

 

Gender, Plan Type, Risk Class, Policy Status, & Duration are the slicers that I have.

I have tried creating a table and using keywords such as VALUE, FILTER, and so on, either using the silcers at inputs to these functions or using the table as an input, but none has worked so far. Any help is highly appreciated! Thanks!

  • Anonymous's avatar
    Anonymous
    7 years ago

    What about a measure that captures the selected values?

    Measure = CONCATENATEX('Table', 'Table'[Value],",")

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    What about a measure that captures the selected values?

    Measure = CONCATENATEX('Table', 'Table'[Value],",")