Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

highlight line chart period + event points

Hi,    I finally have a 365 account so I'm able to ask for help haha. I have searched for solutions on the forum for the past few months but didnt find anything yet. I am making a dashboard for a d...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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. 

     

AnalystPower's avatar
AnalystPower
Icon for Helper I rankHelper I
7 years ago

HelloAnonymous,

 

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.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

AnalystPower unfortunately not :(

I'm getting a power BI course soon, so I can ask for help then :) 

  • jochenj's avatar
    jochenj
    Icon for Advocate III rankAdvocate III
    6 years ago

    I also researching ways how to visualize stock-data as linechart with buy/sell/divident-events like this here:

    my first test with a simple line chart brings me half the way:

     

    Coloring the events by type should be possible with corresonding helper-measures,.. so far i found no way to dynamically add  horizontal lines at start of events (like in the first screenshoot). I will now reasearch if a R-Visual Plot will help here..