I am trying to build a chart with a expression which returns me the top 2 products without using the Top/bottom properties.
I have 2 dimensions in the chart.
But the chart shows error message "visualization failed to error" when there is no data for 1 dimension.
I think It would be better if it shows No data to display instead of that error message.
And I think there is no way to change error message.
So I just wanted to know If there is some way through which I can avoid that error message.
Or Is there another way to modify my expression to achieve desired result.
I have attached sample file.