topic Re: Excluding dimension from a bar chart in App Development

Excluding dimension from a bar chart

Sat, 16 Nov 2024 09:12:49 GMT

Dears

I have a bar chart showing customer and overdue amount, however I need to exclude 2 customers.

I am using this script which is showing all customers

if(Sum({<OverDueStatus={'Overdue'}>}[AmountFinal])<>0,Sum({<OverDueStatus={'Overdue'}>}[AmountFinal]))

Looking Forward to your reply.

Raaj

Re: Excluding dimension from a bar chart

sunny_talwar — Thu, 05 Oct 2017 15:34:03 GMT

May be this

if(Sum({<OverDueStatus={'Overdue'}, Customer -= {'Cust1', 'Cust2'}>}[AmountFinal])<>0,Sum({<OverDueStatus={'Overdue'}, Customer -= {'Cust1', 'Cust2'}>}[AmountFinal]))

Re: Excluding dimension from a bar chart

Thu, 05 Oct 2017 15:44:42 GMT

Sunny,

Excellent, it works.

Cheers man.

Raaj

Re: Excluding dimension from a bar chart

sunny_talwar — Thu, 05 Oct 2017 15:46:59 GMT

Great