Forum Discussion

acbg's avatar
acbg
Resolver III
7 years ago
Solved

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...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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.

 

 

Regards,

Jimmy Tao

  • acbg's avatar
    acbg
    Resolver III
    7 years ago

    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?

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      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

      • acbg's avatar
        acbg
        Resolver III
        7 years ago

        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 :(