Forum Discussion
highlight line chart period + event points
I found a solution to display the period in the line chart by using some filtered measurs with the start and end date. Maybe this helps someone else.
Quantityafter = CALCULATE (
SUM ([quantity]);
FILTER('table';'table'[Posting Date]>=MIN(Dealsperiod[Enddate].[Date])))Quantitybefore = CALCULATE (
SUM ([quantity]);
FILTER('table';'table'[Posting Date]<=MAX(Dealsperiodsheet2[Startdate].[Date])))Quantitydeal = CALCULATE (SUM ([quantity]);FILTER('table';'table'[Posting Date]>=MIN('Dealsperiod'[Startdate])&& 'table'[Posting Date] <=MAX('Dealsperiodsheet2'[Enddate])))And use all 3 as values with the posting date in the axis field.I had to put the start and end date in different tables and make new relationships to the date table so they were recognised as dates.Almost done, now I only need to have the events marked on the thing. Maybe I can do that if I make a line and column chart instead :) And use the collumns as the markers.
Helper IHelloAnonymous,
Did you ever get this to show this way? I have 4 data/date points that I would like to show in a line chart.
AnalystPower unfortunately not :(
I'm getting a power BI course soon, so I can ask for help then :)