Suppress null value bar without excluding null values in calculation of an expression
I have a problem regarding suppress when value is null option in dimension properties of a chart.
I would like to calculate an indicator that takes into account null values in given field. However,on the chart I do not want to see this last bar, where all cases with null values for my dimension fall.
I thought that suppress when value is null option will solve the problem, meaning will hide last bar, but when this option is checked, values for my expression do not count null cases and its value becomes wrong.
I will be gratefull for all your suggestions that may solve my problem.
Re: Suppress null value bar without excluding null values in calculation of an expression
thank you for your interest, I appreciate it very much
Finally I managed to solve my problem. The solution was connected with rebuilding data model and creating 1-1 relation between my tables. I was afraid that duplicating my records will inhibit the app but hopefully, loading it on Access Point did not make any troubles.