How to show greater thaan XXX measure values in bar chart.

[Anonymous]

I am creating bar chart which shows Model Year in X-Axis(Dimension) & Amount Spent in Y-Axis(Measure).

I need to show only Model Year which has more than 50000$ amount spent. Less than 50000$ measure value model year need to hide. 

I am seeing unwanted Model year which has less amount spent in the beginning of chart, need to hide by expression.

Can anyone help how to sort this by expression formula...

[sunny_talwar]

May be change your measure from Sum(Amount) to something like this:

Sum({<Year = {"=Sum(Amount) > 50000"}>}Amount)

[rohitraut]

If(sum(Amount) >=50000,sum(Amount), 0)

Hope this help!

[Anonymous]

Thanks Sunny...

But i am already using IF & SUM expression in measure value to get certain amount..

If( (Sum({$<$(v2017WDSSFULL)>}TOTAL_EXPENSE)) > 0 ,(Sum({$<$(v2017WDSSFULL)>}TOTAL_EXPENSE)))...

Addition to this, i need to show only more thaan $50000 Total_Expense in Model Year Stick.

[Anonymous]

Thanks Rohit...

But i am already using IF & SUM expression in measure value to get certain amount..

If( (Sum({$<$(v2017WDSSFULL)>}TOTAL_EXPENSE)) > 0 ,(Sum({$<$(v2017WDSSFULL)>}TOTAL_EXPENSE)))...

Addition to this, i need to show only more thaan $50000 Total_Expense in Model Year Stick.

[chinnuchinni · Accepted solution]

instead of zero you can try with 50000

[Anonymous]

Thanks Praveen... Now its working....

If( (Sum({$<$(v2017WDSSFULL)>}TOTAL_EXPENSE)) > 50000 ,(Sum({$<$(v2017WDSSFULL)>}TOTAL_EXPENSE)))