topic Re: Display slicer hierarchy values in DAX Commands and Tips

Display slicer hierarchy values

Anonymous — Mon, 17 Jun 2024 12:54:58 GMT

Hello Community,

I have a slicer with hierarchy: level 1: Group Header Code and Level 2 : Group Header Name. However when I select any value from the level 2 it displays automatically the relevant one in level 1 but If I choose the level 1 value from the column Group Header Code it only display the value without the second level.

SelectedValue =

VAR Delimiter = " / "

VAR FilteredValues =

FILTER (

{

IF (

ISFILTERED ( SUPPLIERS[Group Header Code] ),

"Group Header Code: "

& CONCATENATEX (

FILTERS ( SUPPLIERS[Group Header Code] ),

SUPPLIERS[Group Header Code],

", "

BLANK ()

IF (

ISFILTERED ( SUPPLIERS[Group Header Name] ),

"Group Header Name: "

& CONCATENATEX (

FILTERS ( SUPPLIERS[Group Header Name] ),

SUPPLIERS[Group Header Name],

", "

BLANK ()

)},

NOT ( ISBLANK ( [Value] ) )

)

RETURN

"Suppliers : "

& CONCATENATEX ( FilteredValues, [Value], Delimiter )

Can you please help

many thanks

Re: Display slicer hierarchy values

Anonymous — Tue, 18 Jun 2024 03:49:40 GMT

Hi,Anonymous I am glad to help you.

According to your description, you have encountered this problem after creating a measure: when the slicer selects only the first level of the field, the slicer will automatically include all the values of the second field to be automatically checked, but in visual the total column of the measure only displays the value of the first level, but not the value of the second level which is automatically selected by the system.

But you want the total column to display both level1 and level2 values when the slicer selects level1.

like this.

If my understanding is correct, you can refer to my test below

The results of the test are as follows:

Here is the DAX code

M_test = VAR Delimiter = " / " VAR allLevel2_values=CALCULATE("Group Header Name: " & CONCATENATEX ( FILTERS ( SUPPLIERS[Group Header Name] ), SUPPLIERS[Group Header Name], ", " ),FILTER(ALLSELECTED('SUPPLIERS'),'SUPPLIERS'[Group Header Code]IN SELECTCOLUMNS('SUPPLIERS',"level2_values",'SUPPLIERS'[Group Header Code]))) VAR FilteredValues = FILTER ( { IF ( ISFILTERED ( SUPPLIERS[Group Header Code] ), "Group Header Code: " & CONCATENATEX ( FILTERS ( SUPPLIERS[Group Header Code] ), SUPPLIERS[Group Header Code], ", " ), BLANK () ), IF ( ISFILTERED ( SUPPLIERS[Group Header Name] ), "Group Header Name: " & CONCATENATEX ( FILTERS ( SUPPLIERS[Group Header Name] ), SUPPLIERS[Group Header Name], ", " ), BLANK () )}, NOT ( ISBLANK ( [Value] ) ) ) RETURN IF(ISFILTERED(SUPPLIERS[Group Header Code])&&NOT(ISFILTERED(SUPPLIERS[Group Header Name])), "Suppliers : " & FilteredValues & Delimiter & allLevel2_values , "Suppliers : " & CONCATENATEX ( FilteredValues, [Value], Delimiter ) )

Here is my test data:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Display slicer hierarchy values

Anonymous — Tue, 18 Jun 2024 07:31:35 GMT

Thank you Anonymous it worked and issue solved. Many Thanks