Displaying values in a range of dates within custom tooltip

[Anonymous]

Hello,

I have a line chart showing a value over time, and I would like my custom tooltip to display not only the value for the date that is hovered on, but also the previous and next week's values on a line chart. Any ideas on how to achieve this ?

Expected result

Thanks in advance !

[Anonymous]

Hello,

I have still not been able to obtain the desired result. I have tried the suggested solutions, and spent some time trying to figure this out, but I am still stuck.

Using an unrelated date table prevents the date filter from passing to the tooltip and thus being able to display a range of date related to the value hovered on on the main graph. I would like to be able have the tooltip show the line value over - 1week and + 1 week interval relative to the date I hover on. 

Here is a link to a sample file if that can help:

.pbix file 

Thanks a lot,

Pierre

[v-shex-msft]

Hi @Anonymous,

I'd like to suggest you use not related date table field as the axis to design the report tooltip page.
Then you can write a measure on that visual to compare current value and selected value and apply filter effects. (use current date as conditions to filter on date week numbers)

Applying a measure filter in Power BI - SQLBI
Regards,

Xiaoxin Sheng

[Anonymous]

Hi  @amitchandak and thank your for your quick response,

I have created an independant Date table and added the "Week Rank" column.

I am trying to plot the "This Week" mesure against the Date from the new indendent date table in the tooltip, but it is not working. How is the filter supposed to be passed if the main graph date is not part of the filter expression of the measure used in the tooltip ? Sorry if I missed something.

[amitchandak]

@Anonymous , use this week vs last week using date table of week range

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format
measures
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

If you want to show range as the filter is passed, you need to use independent date table in tool tip