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.

     

anandav's avatar
anandav
Skilled Sharer
8 years ago

DieLem

 

Glad you found the solution.

 

Another approach is to use cummulative total pattern:

IncrementTr YTD =
CALCULATE( sum(RegistrationTracking[Increment]), filter(All('Date'), 'Date'[Date] <= Max(RegistrationTracking[SnapshotDate])))

 

The advantage is you don't have to hard code the end date.

 

Check this article :

Calculating Cumulative Or Running Totals In Power BI using DAX

 

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.