Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 %.
Please find the attached. hope it resolves the issue.
1. Added Conditional show for expressions
2. fixed the formula to retain the values
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
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.
What's a difference between DelHours and DeliveryHours?
Please find the attached. hope it resolves the issue.
1. Added Conditional show for expressions
2. fixed the formula to retain the values
I think it would maybe be better to unlink the table with your listbox selection field to create a data island.
hi priya,
Appreciate your quick response, but its working fine but once it reload data it is not working fine.
Thanks,
ASHOK
What is the issue you are facing after the reload?