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

[bodorsey11]

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 we can track against. Any help would appreciated.

I tried this Dax code with no luck. 

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

[v-jayw-msft · Accepted solution]

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

[Ashish_Mathur]

Hi,

In a simple table, show the expected result.  Please also share the download link of the PBI file.

[amitchandak]

@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-...

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-C...