@ZiaAnderson glad to help, feel free to reach out if need any assistance. Accept the solution if it is working as expected so that others can take advantage of it.
Sorry for being so dumb, but I can't figure out how you created the Calendar table in the solution you'd sent. The column "Date" in particular. i see from the icon, that it's not a Measure and not a Calculated column, but the table itself has a formula.
@parry2k Sorry! 2 more questions: 1. On your chart Today shows as a column in 'Column values" section. On mine it gives me an option for a Count, Sum, etc. How do I display it as a just "Today".
2. You have "Tooltip" in the "Tooltips" section. How is that done?
@ZiaAnderson Today is a measure, not a column.
Today = VAR __released = MAXX( ALLSELECTED( 'Calendar'[Date] ), [Released] ) VAR __disbursements = MAXX( ALLSELECTED( 'Calendar'[Date] ), [Disbursements] ) RETURN IF( MAX( 'Calendar'[Date] ) = TODAY(), MAX( __released, __disbursements ) ) * 1.05 --multiply with factor to get longer bar
For tooltip, here is the post
If you still need assistance, please reach out to by email (on my signature) and I can walk you thru screen sharing.
Hi @parry2k ,
I hope you are doing well. Thank you for being our mentor.
I'm running into similar situation where I need to create a vertical line showing current date. I followed this conversation and managed to create the vertical line.
However, the two lines generated using measures became straight horizontal lines (instead of showing actual curves). Could you please have a look and point me to the right direction?
I appreciate your help.
@Hugh can you share what are the measure for those lines and how your data model looks like? Were those lines working before you added today's vertical line?
Hi @parry2k ,
The measures for those lines are:
Thanks @parry2k I downloaded your solution file and got it working - I needed to add a new column for Date2 based on your date +700 because it is now about 2yrs after your dates (so 'today' wasn't showing up).
However my 'today' bar is very thick, not like yours which is a line - just what I want.
Greatly appreciated if you or anyone could share how to make the column a thin vertical line.
Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.