Forum Discussion

DieLem's avatar
DieLem
Helper II
8 years ago
Solved

Hide partial YTD Column

Hi! See image attached. I have a Line and Column chart. The line is this year's Target and the colunms are the current year's Actual values. However it looks iffy with current year's values remain...
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this formula

     

    IncrementTr YTD = if(VALUES('Date'[Date])<=TODAY(),CALCULATE([IncrementTr Total],DATESYTD('Date'[Date],"30/6")),BLANK())

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution here.

     

    Hope this helps.

     

DieLem's avatar
DieLem
Helper II
8 years ago

Hey anandav this also works, thanks!

 

I hear what you say about not hard coding, that's wise.

 

Both solutions work. However when I add a field to the column series to split graph into different revenue streams (PackageCode) it suddenly jumps the whole screen. 

 

Is there a reason for this?

anandav's avatar
anandav
Skilled Sharer
8 years ago

DieLem

An image and some ore details on what you are trying to do will be helpful.