improving temporal line charts in power bi with dax

[Anonymous]

Hi, i made a calculated column in my date table & used that as x-axis in continous line chart:

Year-Month =

EOMONTH ( 'Date'[Date], 0 )

I am following the recommendation here: www.sqlbi.com/articles/improving-temporal-line-charts-in-power-bi-with-dax/

I want to be able to capture the date selected by the user because I use it to compute additional measures & display them in a  table. Note the eomonth is just an example.

The trouble is, the chart only captures the date if i select the line chart (or values). It doesn't capture a date if i select the gridline only. Below shows what i mean by gridline & values.

Can somebody please help?

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

do you need the power bi file or is the example sufficioent to reproduce example? thanks

[Anonymous]

Hi @Anonymous  

You may try to change the Type of X axis or you can try to build another type of visual to see the result.

If the date in gridline is still not the same as the date in values, please show me more details about your problem.

Such as your date model, the result you want and the screenshot of your issue. And which value or measure you use to build the line chart visual. Or you can share me with your pbix file by your Onedrive for business

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

when i select the gridline as shown on 31st may'2020, this measure:

calculate(min(date[monthend]),allselected())

gives me 1st jan 2020, which is the earliest date.

when i select the actual dot on the series of values, i get 31st may'2020 which is the right value.

i expect to get 31st may 2020 when i select the gridline only.

hope that is clear.