Show only dimension value in Chart

[#1]

Hello all,

Underneath the image , you see a chart with dimension StoreCode and Month. In the chart Average orders amount

i only want to show the  used expression for only  the storecode WSDP  and WSBK. in the image below you see irrelevant stores....

How can i fix this? Thanks!

Greets,

Rega

[sunny_talwar · Accepted solution]

May be use a calculated dimension here:

If(Match(StoreCode, 'WSDP', 'WSBK'), StoreCode)

and select 'Suppress When Value Is Null' on the dimensions tab

[sunny_talwar]

Alternatively you can also use a set analysis in your expression. For example your expression was Sum(Sales), then change it to -> Sum({<StoreCode = {'WSDP', 'WSBK'}>} Sales)

I would suggest this approach, unless there is a very specific reason to use calculated dimension.

[#4]

Hey Sunny T,

How can i let the chart show "0" or zero sales ( for example some stores had €0 sales) but still i want to show this in a chart.

Which parameters /settings should i do?

[sunny_talwar]

On the presentation tab -> uncheck 'Suppress Zero Values'