How to show range of month as a tooltip?

[Anonymous]

I have a report which consists of trade data of the country until 2020 of May with a continuous monthly update. Now I want to show that current data consists of data from January-May, then if new data comes for June, it should change to January-June . How can I do that? 

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a new report page called 'Tooltip' and then set 'Tooltip' as on to mark it as a tooltip.

Then you can go to 'Fields' and set 'Keep all filters' off. And you need to make the visual selected which you want to apply the tooltip to, set 'Tooptip' on.

Result:

For further information, you may also refer to the document .

Best Regards

Allan

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

[amitchandak]

@Anonymous , Try like a measure like this in tool tip

measure =

 
var _min = format(minx(allselected(Date),Date[Date]),"MMM-YYYY")
var _max = format(maxx(allselected(Date),Date[Date]),"MMM-YYYY")

return

_min & " "& _max

[Anonymous]

Hello, @amitchandak I tried your method. The method is showing me a date range like January 2011 and June 2020. But I want to something like if I press 2011 year data it must show me January-December because the data till 2019 is full and if I press to the 2020 year data it should show me January-June because of the data are available until June for the 2020 year. 

[Anonymous]

@amitchandak I tried your reply. But I do not know what is a problem,

@amitchandak