Forum Discussion

LukeDurrant's avatar
LukeDurrant
Frequent Visitor
2 years ago
Solved

YTD Line Graph

I want my YTD line graph to show Jan-Oct when Oct is selected on the slicer but it is only showing data for October?  
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi LukeDurrant 

     

    I ran the testing as follows.

     

    My sample:

     

     

    Create a measure as follows

    Measure = IF(MONTH(MAX('Table'[Date])) <= MONTH(SELECTEDVALUE('Date'[Date])), 1, 0)

     

    Put the measure into the visual-level filters, set up show items when the value is 1.

    Is this the result you expect?

     

    Best Regards,
    Community Support Team _Yuliax

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi LukeDurrant 

 

I ran the testing as follows.

 

My sample:

 

 

Create a measure as follows

Measure = IF(MONTH(MAX('Table'[Date])) <= MONTH(SELECTEDVALUE('Date'[Date])), 1, 0)

 

Put the measure into the visual-level filters, set up show items when the value is 1.

Is this the result you expect?

 

Best Regards,
Community Support Team _Yuliax

 

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