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

anandav

 

See this link (File: TrackingExample3):

 

https://drive.google.com/drive/folders/1P10op_192ac_m-QGqt-QjolaLZSIMc_t

 

In the first tab (YTD Revenue [No Column Series]) I have used your formula and it works perfectly! In the second tab (YTD Revenue) I add the 'Revenue Stream' to the Column Series to show the revenue stream breakdown on the bar charts. This stops the whole graph with the lines from going to August and ends it at end of Jan 2018.

 

I want the graph to look like your example in the first tab with lines until August and bars until Jan but with the bars split when there is a parameter added to the Column Series to show breakdown.

 

Thanks!  

 

 

  • anandav's avatar
    anandav
    Skilled Sharer
    8 years ago

    DieLem

    I am stumped. Not sure why this is happening.

    May be Ashish_Mathur can assist.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi anandav,

       

      I thought i have already answered DieLem's question.  Have i missed something?  Is my solution giving any problems?

      • anandav's avatar
        anandav
        Skilled Sharer
        8 years ago

        He has another problem when adding a column to stack chart. Check his latest question.