Forum Discussion
Getting markers for tooltips on the line chart
Hi guys!
I've tried to replicate the following solutions but with no luck:
https://www.youtube.com/watch?v=jaici0AtX5Y&ab_channel=JasonDavidson
My data source is this:
I want to get a line chart with the total sales over time using the main calendar. On top of that i want to insert a date marker for every price change from the price changes table (ie. the date from that table). I've inserted "Starting Date" column on a tooltip and got this:
This is completely fine. HOWEVER, i want to get a marker for these points wherever there exists a Starting Date or better to say i want to transform an active tooltip into a marker. To do that i need to create a new masure with dax and insert it as a value and show it as a marker. The thing is that i cannot get the right expression.
The logic would be something like this:
if there exists a starting date give me a value of that starting date else BLANK()
Any ideas?
3 Replies
- vonschultz666
Helper I
Please note that there are numerous price change dates for each item, so usually i would filter this line chart for only one item. Furthermore, as there are numerous dates, i guess i should use MAX() expression?
- vonschultz666
Helper I
Could anyone help please? 😞
- AnonymousNot applicable
Hi vonschultz666 ,
Please have a try.
Create a measure.
MEASURE=IF(MAX(DATE)="STARTING DATE",MAX(START DATA),BLANK())If it does not help, please provide more details wit your desired output and your pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly