Forum Discussion

JB17's avatar
JB17
Frequent Visitor
1 year ago
Solved

How to Create Trend Based on Date

Hi, Can you please help me create correct DAX to show trend on three given values based on date? Sample trend is below: Would appreciate your responses and help. Thank you so much!       ...
  • Cookistador's avatar
    1 year ago

    Is it what you need to build?

    If it is the case, this is the steps to follow:

     

    1) in visulation select Line chart

    2) In x-axis, select your date

    3) replace the hierachy by the date

     

    4) add the three given values in Y-axis, if you want, you can change the type of aggregation

     

    5)Turn on the data label, In visualizations --> Format your visual

    Search for data label and turn it on

     

     

    If it is not what you are trying to achieve, give us more context like a sample of your dataset and the kind of measure you need to build