Selected slicer

[BIdileepku]

Hi, i have a selected slicer in Tableau same i want to implement it in Power BI 
I have 5 column called level 1 to level 5  i want to show them in a slicer so i have created disconnected table 
and i am using calculated column called( Responce ) which contains Numbers and names and alphabets in the value section in Matrix table 
when i select Level 1 i want to see only the selected level of responce data 
How can i achive it in Power BI

[pankajnamekar25]

Hello @BIdileepku 

try this

Create a Disconnected Table

Go to "Enter Data" and create a table like this:

LevelName

ANZSIC Level 1

ANZSIC Level 2

ANZSIC Level 3

ANZSIC Level 4

ANZSIC Level 5

Name it ANZSIC_Level_Table.

Add a Slicer

Use the LevelName column from ANZSIC_Level_Table in a slicer visual.

Create a Measure to Dynamically Show the Selected Level's Data

Selected ANZSIC Value =

VAR SelectedLevel = SELECTEDVALUE('ANZSIC_Level_Table'[LevelName])

RETURN

SWITCH(

    SelectedLevel,

    "ANZSIC Level 1", SELECTEDVALUE('YourDataTable'[Level 1]),

    "ANZSIC Level 2", SELECTEDVALUE('YourDataTable'[Level 2]),

    "ANZSIC Level 3", SELECTEDVALUE('YourDataTable'[Level 3]),

    "ANZSIC Level 4", SELECTEDVALUE('YourDataTable'[Level 4]),

    "ANZSIC Level 5", SELECTEDVALUE('YourDataTable'[Level 5]),

    BLANK()

)

 Replace 'YourDataTable' with the actual name of your main table.

Use the Measure in Matrix

Place the dimension you want on Rows (e.g., IDs, categories).

Use Selected ANZSIC Value measure in the Values section.

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[BIdileepku]

Hi Pankaj Thanks for your responce 
i created with this measure previously 

VAR SelectedLevel = SELECTEDVALUE('ANZSIC_Level_Table'[LevelName])

RETURN

SWITCH(

    SelectedLevel,

    "ANZSIC Level 1", SELECTEDVALUE('YourDataTable'[Level 1]),

    "ANZSIC Level 2", SELECTEDVALUE('YourDataTable'[Level 2]),

    "ANZSIC Level 3", SELECTEDVALUE('YourDataTable'[Level 3]),

    "ANZSIC Level 4", SELECTEDVALUE('YourDataTable'[Level 4]),

    "ANZSIC Level 5", SELECTEDVALUE('YourDataTable'[Level 5]),

    BLANK()

)
what what are all the data available in the matrix visual is not changing if we select any anzsic levels from the slicer in power BI 
i have added the data column in the dax also it is not changing this is the dax i have used 

VAR SelectedLevel = SELECTEDVALUE('ANZSIC_Level_Selector'[SelectedLevel])

VAR IsMatch =

    SWITCH(

        TRUE(),

        SelectedLevel = "ANZSIC Level 1", NOT ISBLANK(SELECTEDVALUE('Data Table'[ANZSIC Level 1])),

        SelectedLevel = "ANZSIC Level 2", NOT ISBLANK(SELECTEDVALUE('Data Table'[ANZSIC Level 2])),

        SelectedLevel = "ANZSIC Level 3", NOT ISBLANK(SELECTEDVALUE('Data Table'[ANZSIC Level 3])),

        SelectedLevel = "ANZSIC Level 4", NOT ISBLANK(SELECTEDVALUE('Data Table'[ANZSIC Level 4])),

        SelectedLevel = "ANZSIC Level 5", NOT ISBLANK(SELECTEDVALUE('Data Table'[ANZSIC Level 5])),

        FALSE

    )

RETURN

    IF(IsMatch, SELECTEDVALUE('Data Table'[Response]))

[v-sshirivolu]

Hi @BIdileepku ,
Try These Steps to resolve.

Add Disconnected Slicer Table

SelectedLevel 
---------------------
ANZSIC Level 1 
ANZSIC Level 2 
ANZSIC Level 3 

Name this table: ANZSIC_Level_Selector

Do not link this table to Data Table (keep it disconnected).

Create Dynamic Measure

Selected Response =
VAR SelectedLevel = SELECTEDVALUE('ANZSIC_Level_Selector'[SelectedLevel])
RETURN
SWITCH(
SelectedLevel,
"ANZSIC Level 1", MAX('Data Table'[ANZSIC Level 1 Response]),
"ANZSIC Level 2", MAX('Data Table'[ANZSIC Level 2 Response]),
"ANZSIC Level 3", MAX('Data Table'[ANZSIC Level 3 Response]),
BLANK()
)

Add Visuals
1. Add a Slicer:
Drag SelectedLevel from the ANZSIC_Level_Selector table into the slicer.

2. Add a Matrix visual:
Rows: Drag ID from the Data Table
Values: Drag the measure Selected Response

Find the below attached .pbix file for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team 

[BIdileepku]

Hi Sreeteja thanks for your responce 
 i have only only one (calculated/measure) responce column when i tried the dax data is not filtering for the particular Anzsic filters it is showing same  data for all the filters

[v-sshirivolu]

Hi @BIdileepku 

To handle the scenario based on the slicer selection from a disconnected table (ANZSIC_Level_Selector), the following measure can be used to conditionally show rows depending on which level is selected:

Show Row? = 
VAR SelectedLevel = SELECTEDVALUE('ANZSIC_Level_Selector'[SelectedLevel])
RETURN 
SWITCH(
    TRUE(),
    SelectedLevel = "ANZSIC Level 1", NOT(ISBLANK('Data Table'[ANZSIC Level 1])),
    SelectedLevel = "ANZSIC Level 2", NOT(ISBLANK('Data Table'[ANZSIC Level 2])),
    SelectedLevel = "ANZSIC Level 3", NOT(ISBLANK('Data Table'[ANZSIC Level 3])),
    TRUE(), 1
)

This measure checks which level is selected in the slicer and returns 1 only for those rows where the corresponding column is not blank. It also includes a fallback (TRUE(), 1) to avoid filter issues when no slicer selection is made.

To apply this logic:
Add the measure to the table visual
Set a visual-level filter on the measure where Show Row? = 1.

This setup ensures only the relevant rows appear in the visual based on the selected level, resolving the issue where a single value for a column couldn’t be determined due to multiple context values.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team