Bar Chart sorting

[#1]

Hello everyone,

I have a problem with my bar chart sort order.

It should be sorted by value (max first).

Works fine if no filters are selected.

As soon as I apply a filter, the sorting goes crazy and shows null-values. Null-Values shoulden't be shown too...

My sorting expression looks like sum(Value).

Anyone know this problem?

Best regards,

Moritz

[Anonymous]

you need sort to sort by Y-value (descending)

and in the presentation tab, make sure you have checked "Suppress Missing" and "Suppress Zero-Values" to hide null and zero values

[sushil353]

Hi,

You can check option for remove null values in Dimension tab..

HTH

Sushil

[ashfaq_haseeb]

Hi,

Go to chart properties --> Sort --> Select sort by y value.

Regards

ASHFAQ

[#5]

Thank you guys for your quick answer.

To to NUll-Value problem:

I already did what you suggest. All of these options are checked.

To the sorting-problem:

As I have 2 Dimensions (always only one visible), the sort by Y-value isn't available for the second...

So thats why I tried it with sum(value)...

Any suggestions?

[ashfaq_haseeb]

Hi,

Can you attache sample to check with.

regards

ASHFAQ

[#7 · Accepted solution]

Ah, I found the solution to my problem.

In the Dimension Limits I say 'Show only values that are: Greater Than 0 exact amount', the sorting works just fine & there are no NULL-values...

Anyway, thank you for your help !

Best regards & have a nice day!

Moritz