Forum Discussion

nedian_bilal's avatar
nedian_bilal
Frequent Visitor
3 years ago
Solved

Dynamic percent Change in Guage Chart using Subtotals

Dear All,

 

I have a project with 4 major different locations. I have 3 types of Slicer to filter my data as shown in the figure. I have only 1 value column named "WTG" in my data table whose total value is 100. This total value 100% is further divided into location based as per location.

 

Construction = 100%

3rd River Facility = 26.77%
GIFT = 56%
Pipeline = 10.83%
Wellpads = 6.4%

 

I want that when select Construction from 1st Slicer, then the Guage show me the values and variance as 100%.


And when I select from 2nd Slicer, then it showing me its own breakup value from 100%. However, I want to see the value of that selected slicer to give me its own percentage so that variance of that particular selected item will be true depiction.

 

 

Here is the link of my Power Bi File.

https://1drv.ms/u/s!Agpdf8NkY3iotR432mi9Ke0UtE5N?e=Yz0uZy

Need Help from you guys. Thanks

Need Help
Show and Tell
  • nedian_bilal's avatar
    nedian_bilal
    3 years ago

    I have solved this problem myself... however posting it here for others who are seeking similar type of issue...
    1st I created 2 New Measures

    # 1

    Plan % = CALCULATE(SUM(P_Values[WTG]),Filter(ALL(Dates),Dates[Date] <= MAX(Dates[Date])))
     
    #2
    WTG total for WBS_Code_2 =
    CALCULATE(SUM('Activities'[WTG]), ALLSELECTED('Activities'[WBS_Code_2]))
     
    #3
    Divide these 2 measure and got the result...

3 Replies

  • nedian_bilal's avatar
    nedian_bilal
    Frequent Visitor
    3 years ago

    I have solved this problem myself... however posting it here for others who are seeking similar type of issue...
    1st I created 2 New Measures

    # 1

    Plan % = CALCULATE(SUM(P_Values[WTG]),Filter(ALL(Dates),Dates[Date] <= MAX(Dates[Date])))
     
    #2
    WTG total for WBS_Code_2 =
    CALCULATE(SUM('Activities'[WTG]), ALLSELECTED('Activities'[WBS_Code_2]))
     
    #3
    Divide these 2 measure and got the result...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, nedian_bilal ;

    I am very happy to hear that your problem has been solved, thank you for sharing,can you kindly mark the proper reply as a solution to help others having the similar issue and close the case?
    Thank you again.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.