Forum Discussion

PBInonpro's avatar
PBInonpro
Helper III
3 years ago
Solved

Combo Chart - Assistance and Ideas request

I am trying to create a graph to track a buying plan and budget for buying.    I apologize for the crude design (attached), but I would like it to show the total buying plan limit as $ and % from J...
Need Help
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, PBInonpro 

     

    You can try the following methods.

    Measure:

    Sum = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Month]<=SELECTEDVALUE('Table'[Month])))
    % = Var _all=20000
Return
DIVIDE([Sum],_all)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, PBInonpro 

 

You can try the following methods.

Measure:

Sum = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Month]<=SELECTEDVALUE('Table'[Month])))
% = Var _all=20000
Return
DIVIDE([Sum],_all)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 
PBInonpro's avatar
PBInonpro
Helper III
3 years ago

Thanks! Is there a way to merge the projected and actual to show the full range of Jan - Dec.