Data bars seem incorrect when the specific row is filtered

[vcb_001]

Hi,

I have an issue in the table of my report. Let me quickly explain what I couldn't achieve using conditional formatting option of the cell elements in my table (Data Bars).

The above screenshot shows the overall view of the table where no filter is applied etc. and the conditional formatting based on those two columns works very well with the data bars option. However, as you can see in the below screenshot, I can't get the same view as I have in the above one for that specific row when I use the filters. I got the same problem for each specific row when I use the filter. Could you please help me to solve this issue with a smoother way? or could you please tell me the reason why I'm not able to retrieve same view when I use the filter.

Thanks for your help in advance.

[amitchandak · Accepted solution]

@vcb_001 , As of now it is not clear that there are two measures/fields on one. Usually each field will have it own min and max and based on that the bars will be there.

You can give custom value from 0 to 100 or 0 to 1 (In case of % column)

for each data bar field