Percentage issue in bar chart after filter selection

[ashokpaladugula]

Hi all,

With out selection filters, the percentage calculation is showing as expected. but if i select filter as 2 hrs the calculation showing 100%.

For instance,

Before selection of filter 2 hrs.

Jan month shipments percentage is 23.3 %.

After selection filter 2 hrs,

Jan month shipments percentage is 100%.

Here my requirement is after selection of filter delhours as 2 hrs need to show 23.3 %.

swuehl‌stalwar1‌hic‌

[krishnacbe]

Hi,

You can exclude the selection of DelHours from your chart expression as below.

Sum({1<DeliveryHours ={"<=2"}>} [Shipment Count] ) / Sum({1}[Shipment Count])  apply the exclusion for all the three expressions

[ashokpaladugula]

hi priya,

Appreciate your quick response. But my issue is when i select 2hrs as a filter then in the chart there should be only 2hrs bar with 23.3%.Remaining bars should not shown in the chart.

[sunny_talwar]

What's a difference between DelHours and DeliveryHours?

[krishnacbe · Accepted solution]

Please find the attached. hope it resolves the issue.

1. Added Conditional show for expressions

2. fixed the formula to retain the values

[swuehl]

I think it would maybe be better to unlink the table with your listbox selection field to create a data island.

[ashokpaladugula]

hi priya,

Appreciate your quick response, but its working fine but once it reload data it is not working fine.

Thanks,

ASHOK

[krishnacbe]

What is the issue you are facing after the reload?