Forum Discussion
Dynamic Percent change while filtering
Hi Dear All, I have one challenge... I have 3 Project Location columns and 1 value columns in pwer Bi. I want to see percentage in Card chart and it should be link with locations. means i select ...
Example
below is the example sheet. The card percentage should show the overall percentage if i select Construction, and under construction, if i select locations like 3rd River or GIFT then it should not show percentage 30% for 3rd River and 70% for Gift.. it should be transformed into 100%.
| Activity ID | Activity Name | BL Start | BL Finish | Forecast Start | Forecast Finish | WTG | WBS_Code_1 | WBS_Code_2 | WBS_Code_3 |
| A001 | A | 17-Feb-22 | 31-May-22 | 20-Sep-22 | 6-Oct-22 | 10.00% | Construction | 3rd River Water Intake Facilities | Civil |
| A002 | B | 1-Jun-22 | 28-Sep-22 | 4-Dec-22 | 12-Jan-23 | 8.00% | Construction | 3rd River Water Intake Facilities | Mech |
| A003 | C | 2-Jun-22 | 22-Jun-22 | 17-May-22 | 5-Oct-22 | 12.00% | Construction | 3rd River Water Intake Facilities | Electrical |
| A004 | D | 22-Jun-22 | 19-Jul-22 | 9-Mar-23 | 5-Apr-23 | 13.00% | Construction | GIFT Area | Civil |
| A005 | E | 23-Jun-22 | 9-Dec-22 | 27-Feb-23 | 12-May-23 | 7.00% | Construction | GIFT Area | Mech |
| A006 | F | 27-Jul-22 | 21-Feb-23 | 13-Jan-23 | 8-Mar-23 | 5.00% | Construction | GIFT Area | Electrical |
| A007 | G | 22-Feb-23 | 14-Mar-23 | 13-May-23 | 2-Jun-23 | 15.00% | Construction | GIFT Area | Instrument |
| A008 | H | 15-Mar-23 | 7-Apr-23 | 3-Jun-23 | 26-Jun-23 | 10.00% | Construction | GIFT Area | Structure |
| A009 | I | 15-Mar-23 | 29-Mar-23 | 13-May-23 | 27-May-23 | 20.00% | Construction | GIFT Area | ABC |
| A010 | J | 23-Jun-22 | 7-Jul-22 | 20-Oct-22 | 3-Nov-22 | 0.00% | Commissioning | Commissioning | Commissioning |
| A011 | K | 8-Jul-22 | 12-Jul-22 | 4-Nov-22 | 8-Nov-22 | 0.00% | Commissioning | Commissioning | Commissioning |