Forum Discussion
Hide partial YTD Column
Hi,
Try this formula
IncrementTr YTD = if(VALUES('Date'[Date])<=TODAY(),CALCULATE([IncrementTr Total],DATESYTD('Date'[Date],"30/6")),BLANK())
I'll let DieLem clearly mention his problem.
You're solution works, however I can't use the Column Series to further change the way the colunms display. Once I add a criteria to the Column Series it cuts off the lines. Here an edited version of my problem to 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 another I have received, they both work 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!
You are welcome. If my reply helped, please mark it as Answer.