Bar Chart - Show all values - keep order

[prees959]

Hi,

I have a bar char which shows a dimension by day of the week:

I need to be able to show all values when one say is selected  and also keep the sort order of Monday to Sunday is this possible rather than pushing the selected day to the end of the axis :

also - is there a way to hide the dimension with no value  : '-' ??

Thanks,

Phil

[shraddha_g]

Uncheck Show Null Value in Dimension Tab

[effinty2112]

Hi Phil,

If you expression is of the form

Count(Shift)

change it to

Count({$<Day=>}Shift)

Where Day is the day dimension on your x axis. Now the expression will ignore selections on that field. To get rid of the '-' in the dimension tab check the option to suppress When Value Is Null.

Good luck

Andrew

[tresesco]

Check attached sample.