Forum Discussion
Solved
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 p...
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.
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
