Forum Discussion
MSAYED26
Helper II
2 years agoDynamic vertical line in line chart
Hello,I want to add a dynamic vertical line by action date in line chart Action Date 01-10-2022 01-02-2023
Anonymous
2 years agoNot applicable
Hi MFelix ,Thanks for your quick reply, I will add more.
Hi MSAYED26 ,
If you have multiple dates, you need to create multiple measures.
The Table data is shown below:
Use the following DAX expression to create a column
Rank = RANKX('Table 2',[Action Date],,ASC,Dense)
Use the following DAX expression to create measures
Measure = MAXX(FILTER('Table 2',[Rank] = 1),[Action Date])Measure 2 = MAXX(FILTER('Table 2',[Rank] = 2),[Action Date])Measure 3 = MAXX(FILTER('Table 2',[Rank] = 3),[Action Date])
Final output
Best Regards,
Wenbin Zhou
If this post helps, please mark MFelix as the solution.
MSAYED26
Helper II
2 years agoThanks for reply,but can you find other way , because i have more than 20 action date