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. 

     

Anonymous's avatar
Anonymous
Not applicable
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 :)