cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Cobra77 Member
Member

Change the level of the legend dynamically on bubble charts

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

3 REPLIES 3
Community Support Team
Community Support Team

Re: Change the level of the legend dynamically on bubble charts

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cobra77 Member
Member

Re: Change the level of the legend dynamically on bubble charts

bubblechart.jpg

 

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 Member
Member

Re: Change the level of the legend dynamically on bubble charts

 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