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. 

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

It's pleasant that your problem could be solved, could you please mark your reply as answer to let more people know?

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

yes, but I unfortunately didnt find the solution to the other problem (to mark when we send mailings and stuff). 

  • 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..