Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with a bar chart. When I try deleting the null values I dont need, the chart creates a new label named "-".
To delete the Null values I use "Alt(expresion,' ')" or "If(IsNull(Expresion),' ',Expression)".
-->
BTW, the values Im trying to erase are from a second expression without bars.
Once you use your calculated dimension, you need to check 'Suppress When Value Is Null' on the dimension tab of the chart properties to hide those null values
Once you use your calculated dimension, you need to check 'Suppress When Value Is Null' on the dimension tab of the chart properties to hide those null values
Hi,
Here is the another way,with out using the supress null values,we can restrict it by using set analysis.
sum({<sales-={'0'}>}sales)
--surendra