Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Many of the values in my legend, do not show up in my bar chart at all.
How do I hide those values?
For example 'EM bonds' has no data in this chart and therefore I don't want it to appear in the legend. However WCLK does, so i want it to stay in the legend
Hi
Try like this
Case1:
Tick the suppress when value is zero from presentation tab.
Case 2:
There may be the value for "EM Bonds" which is very minimum when compare to others. so it does not displaying. If you select EM Bonds alone, you can able to view it.
Case 3:
If you need to display only top 10 products, then try like this
Sum({<Product = {"=rank(sum(Sales))<= 10"}>} Sales)
Hi
Try like this
Case1:
Tick the suppress when value is zero from presentation tab.
Case 2:
There may be the value for "EM Bonds" which is very minimum when compare to others. so it does not displaying. If you select EM Bonds alone, you can able to view it.
Case 3:
If you need to display only top 10 products, then try like this
Sum({<Product = {"=rank(sum(Sales))<= 10"}>} Sales)
Thanks. The first one worked!