Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Legend label changing based on filtering

I have 3 dimensions on a scattered chart

d1,d2,d3

Initially the legend values will be based on d3 but when I filter the legend changes based on d2 or d3 based on level of filtering. I want the legends to always be based on d3.

How can I achieve this?

8 Replies
Clever_Anjos
Employee
Employee

Check "Persistent Colors" at Colors Tab

Not applicable
Author

Thanks for reply, but it does not help. I am not worried abut the color, but the actual labels on the legend. I don't want labels to change.

Not applicable
Author

I am kind of stuck at this step, I will appreciate the response.

Clever_Anjos
Employee
Employee

There´s a small trick using a straight table.

PFA

Not applicable
Author

Thanks, I looked at the file, I didn't get the point? Is there something specific I need to look for. I looked at expressions and Legend and popup label but didn't find anything.

Can you give me some detail.

My issue is since I have multiple dimensions, the legend labels are changing automatically based on filtering.

Not applicable
Author

for eg

Initially legend labels are

a,b,c based on the dimension 3. When I filter to show only one point

The legend labels change to 128 and so on based on the first dimension which is id.

Clever_Anjos
Employee
Employee

1) First hide the legend of the graph

2) Create a straight table with your colors

3) Position your table over the scatter

Capturar.PNG.png

Not applicable
Author

Thanks a lot lot for your help. I am trying this option to see if it helps me.