Bar chart with value range selection

[#1]

Hello,

I am new to the community, so I would appreciate your help.[:D]

I am trying to display sales data within some range (the minimum and maximum values are variables and are their values are entered by the user ).

My Bar chart Expression syntax is: =Sum([Quantity]*[Unit Price]-OrderDiscount)

I've created two variables: MinSalesValue and MaxSalesValue and I entering their values through the Input Boxes

I was not able to find the syntax to update the bar chart expression to display values within the entered range. What's the best way to do that?

Regards,

DT

[#2 · Accepted solution]

Use If condition in chart expressions and in that u can give range for min and max values .

example: if( sum(sales) =minSales or sum(sales) =maxSales ,sum(sales))

U can try more...

[#3]

It works. Thanks!

Best regards,

DT