cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
acbg Resolver II
Resolver II

Graph with values as interactable

Is it possible to have two charts interact if it has values instead of categories/axis.

 

I have two charts: One clustered column chart with 4 values and the other one is a line chart with Month on axis and same 4 values.

 

When I click on a value in the column chart, I would like the line chart to show only one value. Currently its not interacting.

 

Is there a way to do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Graph with values as interactable

Hi acbg,

 

The interaction/relationship between charts is based on related columns. In addtion, some chart doesn't support measure while some charts support. So if you need to use measure to filter other chart, there should be related columns.

 

Regards,

Jimmy Tao

View solution in original post

5 REPLIES 5
Community Support
Community Support

Re: Graph with values as interactable

Hi acbg,

 

Are both visuals based on same columns in your report? If they are, please click Format-> edit interactions and check if the right-top hand icon in the stacked column visual has been disabled.

Capture.PNGCapture1.PNG 

 

Regards,

Jimmy Tao

acbg Resolver II
Resolver II

Re: Graph with values as interactable

Hi @v-yuta-msft

 

No they are not disabled.

 

I only see it working interactable if there is category.

 

It does not seem to work if its just column values/measures. Is that by design?

Community Support
Community Support

Re: Graph with values as interactable

Hi acbg,

 

The interaction/relationship between charts is based on related columns. In addtion, some chart doesn't support measure while some charts support. So if you need to use measure to filter other chart, there should be related columns.

 

Regards,

Jimmy Tao

View solution in original post

acbg Resolver II
Resolver II

Re: Graph with values as interactable

Thanks @v-yuta-msft 

 

that was what I was afraid of as well. There is not a way for the same measures in two graphs to interact without coloumns 😞

 

Community Support
Community Support

Re: Graph with values as interactable

Hi acbg, 

 

Yes, you may share your idea here to let PG knows your requirement.

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.