Forum Discussion
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 we can track against. Any help would appreciated.
I tried this Dax code with no luck.
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
3 Replies
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
Hi,
In a simple table, show the expected result. Please also share the download link of the PBI file.
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
