Change the level of the legend dynamically on bubble charts

[Cobra77]

Hi,

We have a tree for our organization.

How with bubble chart, dynamically show  level 2 when one of level1 is selected , show level3 when one of level2 is selected etc....

Exist a hierarchy for this dimension.

Thanks for your help if its possbile

[v-jiascu-msft]

Hi @Cobra77,

Which Bubble chart?

Can you share a sample? Usually, when Level 1 is selected, the corresponding Level 2 will be filtered.

Best Regards,

Dale

[Cobra77]

its filtered ok , but we want the level to change in the legend

Niveau2 is in the Legend in this sample.

We want Niveau3 if the filter is on level 2 and so on

we can not put a measure in the legend ...

[Cobra77]

 i try with a measure , for the test i pass level 1 and name TOTO

TF test:=

VAR levl = 1     //   IF (HASONEFILTER('02 - Arborescence'[Level]) && HASONEVALUE('02 - Arborescence'[Level]);VALUES('02 - Arborescence'[Level] ) ;  -1 )

VAR nam = "TOTO"

// VAR List = CALCULATETABLE ( VALUES('02 - Arborescence'[Nom]) 
// ; '02 - Arborescence'[Division] = nam 
// ; '02 - Arborescence'[Level] = levl + 1)

VAR Filt = FILTER('02 - Arborescence'; '02 - Arborescence'[Level2] =
CALCULATETABLE ( VALUES('02 - Arborescence'[Nom])
; '02 - Arborescence'[Division] = nam
; '02 - Arborescence'[Level] = levl + 1) )
RETURN CALCULATE([TF]; Filt)

but :

 - How re filter name with only level2

- why i cant  VAR Filt = FILTER('02 - Arborescence'; '02 - Arborescence'[Level2] = List)  or VALUES (List)  ( if i delete comment )

Thanks