Forum Discussion

bodorsey11's avatar
bodorsey11
New Member
4 years ago
Solved

Need Help: Monthly Target Line for Line and Cluster Column Chart

I am struggling to have my Monthly Target line show properly on a Line and Cluster column chart. It will only show as a flat line, instead of what I am trying to get which is monthly target line that...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi bodorsey11 ,

     

    Please try this formula:

    NY Monthly Targets =
CALCULATE (
    MAX ( 'NY Monthly Target'[Planned Target] ),
    FILTER (
        ALLSELECTED ( 'NY Monthly Target' ),
        'NY Monthly Target'[Date].[Month] = SELECTEDVALUE ( 'Calendar'[Date].[Month] )
    )
)

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

bodorsey11 , if the target table is joined with calendar table then simply this should work

 

SUM('NY Monthly Target'[Planned Target])

 

In case you only have month, the create date using the month year and join both your data and target with a common date table

 

Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400