topic Re: Show all possible dimensions after selection in App Development

Show all possible dimensions after selection

joshuahirsch — Sat, 16 Nov 2024 06:35:40 GMT

Hello there,

problem is simple, but I have no solution for it. (Probably some set analysis, but I'm quite bad in it..)

I have a chart for count of missions over months

Over month, no selection

If I do a selection, which result in one or more months with 0 records, they disappear.

Selection "only tuesdays", July is missing

But I want to see all months for all the time. So July should be there, with a 0, but it should be there.

How to do that?

Thanks so much in advance!

Re: Show all possible dimensions after selection

pradosh_thakur — Thu, 14 Feb 2019 10:08:06 GMT

Have you enabled the inlude zero values as well ?
If you dont want any selection t effect the calculation you can write insdie the set expression {<field_youdont_want_to_effect_the_selection>}

Re: Show all possible dimensions after selection

joshuahirsch — Thu, 14 Feb 2019 10:20:26 GMT

Hi,

"include NULL-Values" is checked.

Well I want that selections affect the chart and change it.

But if a selection returns 0 values in july, i want to see july in the chart with 0 values.

Re: Show all possible dimensions after selection

pradosh_thakur — Thu, 14 Feb 2019 10:24:04 GMT

Add ons-> data handling -> include zero values

Re: Show all possible dimensions after selection

joshuahirsch — Thu, 14 Feb 2019 10:32:15 GMT

Oh thanks, I never knew that there is this Option as well.

But I have checked all 2, but july is still missing

Re: Show all possible dimensions after selection

PrashantSangle — Thu, 14 Feb 2019 10:37:06 GMT

You always want all 12 months to display as bar???

Re: Show all possible dimensions after selection

joshuahirsch — Thu, 14 Feb 2019 10:58:48 GMT

exactly!

Re: Show all possible dimensions after selection

ToniKautto — Thu, 14 Feb 2019 11:14:00 GMT

It is of course accurate that the month is not visible, when it is not part of the current data selection.

However, you can get all the values back in dimension by introducing a aggregation that includes all the dimensions.
Try adding something like +sum({<Month=>} 0 ) to the bar measure.