Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to filter table using preselected slicer text value

Hi all, I have initial data table "dummy" consist of (minimum) two column in which one of them can be used as a filter. The filter set is in column 'country' and expect the user to either select the...
Filter Table
power bi
Slicer
  • Stachu's avatar
    Stachu
    3 years ago

    but still couldnt create the filtered table from the initial 'dummy'. perhaps you have any better idea on that?

    In general it is technically not possible to interact with the slicer and change values in the underlying dataset table (in this case filter for a single country). You can do that with Power Query parameter, but users will not have access to it from the report level, see more here:

    https://community.powerbi.com/t5/Desktop/Passing-Slicer-Selection-to-Query/td-p/1136501

    Why do you need subset of dummy as a materialized table? Formula engine can materialize  it on the fly if it's used in a measure, e.g. inside CALCULATE, but duplicating the subset based on a slicer is not gonna work.

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
3 years ago

Calculated tables are calculated only on refresh, they do not change with the slicer selection. They also are calculated in the most general filter context (no filters at all), which means that

VAR _selectedValue = SELECTEDVALUE(CountrySlice[Value])

always returns blank, which then makes 'Table' an empty table.

 

Why not just create join between 'CountrySlice' and 'dummy'? That would generate visual (so essentially a query) which will filter the 'dummy' table according to the selection you made.