Graph

[Naveen29]

I would like to show the line graph based on selected value of  YYYY and MM and x axis should change accordingly . Dots are 12 months aggregration metric of sales. Date ranges are on x axis 

[v-nmadadi-msft]

Hi @Naveen29 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @Naveen29 ,

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 our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @Naveen29,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[SafdarHussain]

Hi, I understand your situation.
Let me understand what you are trying to ask - and that is - 
i. To show x axis as selected value from date table and previous months which should be aggregation of sales from each month. 
Firstly, you might require to fix the date table. Don't put a range rather Month-Year which could be in MMM-YYYY - So fix that on table side. If you are using the date table directly from the fact table than I would recommend creating a dimensional table and connecting that dimensional table with the dates of fact table and use that dimensional table for the graph.