Filtering error bar in clustered column chart

[adbm]

Hi,

I'm trying to show the min and max price range of different products in my dataset. Im using a clustered column chart with error bars to do that. My visual looks like this. I have different products on the x-axis so each bar is a product. I would like to show only those products where this difference is higher than 5%. Is it possible to apply a filter on the error bars? I know i can add a calculated column and then filter the data but wanted to know if we can directly filter on the visul somehow.

Thank you,

[suparnababu8 · Accepted solution]

Hi @adbm 

It seems like you’re working on a detailed data visualization! Unfortunately, Power BI, don’t allow direct filtering based on error bars.

What ever the approch your are thinking that is correct. Create a calculated columns and apply filters on that visual by using visual level filters. 

=IF((MAX_PRICE - MIN_PRICE) / MIN_PRICE > 0.05, "Show", "Hide")

Hope this helps you.

[adbm]

Ahh ok. Thank you for confirming