Forum Discussion
Selected slicer
Hi Anonymous
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 shows 1 only for rows where the selected slicer level's column isn't blank, with a fallback to handle no selection. Add it to your table visual and filter for Show Row? = 1 to display only relevant rows.
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
Hi Anonymous ,
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
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
Hi Anonymous
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 shows 1 only for rows where the selected slicer level's column isn't blank, with a fallback to handle no selection. Add it to your table visual and filter for Show Row? = 1 to display only relevant rows.
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 TeamHi Anonymous ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Thank you.
Hi Anonymous ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.