Forum Discussion
Filtering error bar in clustered column chart
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,
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.
2 Replies
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.
Ahh ok. Thank you for confirming
