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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Oodi
Frequent Visitor

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:
selected.png
Value selected from a visual.
unselected.png

 

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?

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

Hi @Oodi ,

Based on my testing, please try the following methods:

1.Create the simple table.

vjiewumsft_0-1718016210982.png

vjiewumsft_1-1718016226371.png

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

vjiewumsft_2-1718016235284.png

 

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.

vjiewumsft_3-1718016241533.png

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.

View solution in original post

3 REPLIES 3
v-jiewu-msft
Community Support
Community Support

Hi @Oodi ,

Based on my testing, please try the following methods:

1.Create the simple table.

vjiewumsft_0-1718016210982.png

vjiewumsft_1-1718016226371.png

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

vjiewumsft_2-1718016235284.png

 

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.

vjiewumsft_3-1718016241533.png

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.

xifeng_L
Solution Sage
Solution Sage

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.

 

xifeng_L_0-1717950822488.png

 

 

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

 

Thank you~

 

Oodi
Frequent Visitor

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.