I hve Attached a Screenshot in which the First chart(i.e 1) is Normal ,this bar keep on changing for different dealers, so wen all the month values are below
the Target(i.e 1.7) the Reference line disappears. So i tried using static min and max, fixing min as 0 and max as 1.7 , but if the value is above 1.7 the values
will not be displayed on bars as showed in second chart(i.e 2), so i tried increasing static max value upto 10 which is shown in chart 3, then both reference line as well as Values will appear. But every time it is difficult to predict the maximum value and then to fix, so is there any other possible way, can i use some expression in statc min and max . I also tried using min and max functions to my expreesion but it didnt work.
Expression i am using is :
count({<[Complaint Source]={'TKM','Dealer, TKM','TKM, TMC','Dealer, TKM, TMC'},[Complaint Related To]={'Sales'}>}[Complaint Number])
I have the same issue, that i have some values that are hard to see becauase their values are so low. So i changed the min and max. But i cannot control it dynamic, because if they some day comes above my max, there will be no values shown at all.
Maybe you could try something in the min and max expression
If(count({<[Complaint Source]={'TKM','Dealer, TKM','TKM, TMC','Dealer, TKM, TMC'},[Complaint Related To]={'Sales'}>}[Complaint Number]) > =10,100, count({<[Complaint Source]={'TKM','Dealer, TKM','TKM, TMC','Dealer, TKM, TMC'},[Complaint Related To]={'Sales'}>}[Complaint Number]))
