How to show the last one year sales in Tool Tip Chart irrespective of the Date Range in Main Rpt

[reddy421]

Hi,

I developed a dashboard to show the sales of all the stores. I used Map visualization to show all my stores based on latitude and longitude.

My Question is, If I select a date range of 7 days, I am getting the sales for last 7 days and it is showing the values in the report and also in the tooltip.

Is there a way I can show the last one-year sales trend on the tooltip irrespective of what the date range in my main report is?

FYI...

 

[v-yuezhe-msft]

@reddy421,

I am unable to reproduce this issue when creating a tooltip page following the guide in this article and select slicer in main report page. The tooltip is not filtered by the slicer selection.

Do you use sync slicer feature is Power BI Desktop? This feature will make all visuals in different report pages filter by a single slicer.

Regards,
Lydia

[reddy421]

Below are the steps I did to achieve this.

First I went to File->Options and Settings->Options and enabled the report page tooltips. ( shown below)

After my main page is done, I created one more page and created my tooltip visualization there. ( As shown below)

[reddy421 · Accepted solution]

I was able to achieve this by creating another dataset with one full year sales for all the stores and use that to show that in my line chart

.