Forum Discussion

nedian_bilal's avatar
nedian_bilal
Frequent Visitor
3 years ago

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 location or its sub location so it show me cumulative percentage of that selected location only.

 

The below Picture shows the 100% when i Select Construction in left corner of the sheed which is OK.

 

But when i select the location it shows me the breakdown percentage, however I want to see of that selected location as whole out of 100%.

 

 

Below is the Power QUery

 

 

can someone help me out?

Need Help
Show and Tell

5 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    3 years ago

    Please share non-confidential actual data (not an image) and a depiction of the expected outcome 

  • nedian_bilal's avatar
    nedian_bilal
    Frequent Visitor
    3 years ago

    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 IDActivity NameBL StartBL FinishForecast StartForecast FinishWTGWBS_Code_1WBS_Code_2WBS_Code_3
    A001A17-Feb-2231-May-2220-Sep-226-Oct-2210.00%Construction3rd River Water Intake FacilitiesCivil
    A002B1-Jun-2228-Sep-224-Dec-2212-Jan-238.00%Construction3rd River Water Intake FacilitiesMech
    A003C2-Jun-2222-Jun-2217-May-225-Oct-2212.00%Construction3rd River Water Intake FacilitiesElectrical
    A004D22-Jun-2219-Jul-229-Mar-235-Apr-2313.00%ConstructionGIFT AreaCivil
    A005E23-Jun-229-Dec-2227-Feb-2312-May-237.00%ConstructionGIFT AreaMech
    A006F27-Jul-2221-Feb-2313-Jan-238-Mar-235.00%ConstructionGIFT AreaElectrical
    A007G22-Feb-2314-Mar-2313-May-232-Jun-2315.00%ConstructionGIFT AreaInstrument
    A008H15-Mar-237-Apr-233-Jun-2326-Jun-2310.00%ConstructionGIFT AreaStructure
    A009I15-Mar-2329-Mar-2313-May-2327-May-2320.00%ConstructionGIFT AreaABC
    A010J23-Jun-227-Jul-2220-Oct-223-Nov-220.00%CommissioningCommissioningCommissioning
    A011K8-Jul-2212-Jul-224-Nov-228-Nov-220.00%CommissioningCommissioningCommissioning