How to Create Trend Based on Date

[JB17]

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!

[v-karpurapud]

Hi @JB17 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @JB17 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hi @JB17 

Could you please confirm if your query have been resolved the solution provided by @Cookistador ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.


Thank You.

[Cookistador · Accepted solution]

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