Forum Discussion

Oodi's avatar
Oodi
Frequent Visitor
2 years ago
Solved

Measure value does not change dynamically in an error bar when selecting value from a visual

Hello, 

I'm trying to make a measure value change dynamically in an error bar (low point) by selecting a value from a visual like table or matrix.

 

For some reason when selecting a value from any visual other visuals are filtered by it but the error bar (low point) value is not filtered. However when selecting a value from a slicer also the error bar value filters. 

Value selected from a slicer:

Value selected from a visual.

 

Currently the measure value only reacts to slicer selection but when selecting value from a visual the error bar value remains unfiltered.

Measure in the error bar is a basic SUM() in a CALCULATE()

Any ideas?

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Oodi ,

    Based on my testing, please try the following methods:

    1.Create the simple table.

    2.Drag the Inventory table item field into the table visual.

     

    3.Create the new measure to calculate the values based on the table visual selected.

    Sum Transaction = 
CALCULATE(
    SUM('Inventory table'[Quantity]),
    FILTER(
        'Inventory table',
        'Inventory table'[Item No] = SELECTEDVALUE('Table'[Item No])
    )
)

    4.Select the Item in the table visual and the result is shown below.

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • xifeng_L's avatar
    xifeng_L
    Icon for Super User rankSuper User
    2 years ago

    Hi Oodi 

     

    Assuming the expression is correct, it is possible that the interaction between visual objects is blocked, you can check if the option is checked as shown below.

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

     

    • Oodi's avatar
      Oodi
      Frequent Visitor
      2 years ago

      Thanks for the idea, 
      checked and the option was disabled. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Oodi ,

    Based on my testing, please try the following methods:

    1.Create the simple table.

    2.Drag the Inventory table item field into the table visual.

     

    3.Create the new measure to calculate the values based on the table visual selected.

    Sum Transaction = 
CALCULATE(
    SUM('Inventory table'[Quantity]),
    FILTER(
        'Inventory table',
        'Inventory table'[Item No] = SELECTEDVALUE('Table'[Item No])
    )
)

    4.Select the Item in the table visual and the result is shown below.

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.