How to filter Current Date Time stamp column to the Top 1 in page level filter in Push Data set

[harishkola]

I am using push data set to build my report which includes filters and Card visual and graphs. For every 3 minutes data is pushed into Data set. I was able to filter to the latest current date time in card visual and graphs while showing data but I was not able to filter the slicers that i wanted to use since we can't filter the slicers in visual level filter.

So If I was able to filter the whole page to the latest Current Date time then I think my problem will be solved which I was unable to do that because it's not letting me to choose the Top 1 Latest Current time, it was only available in visual level filter.

Can any one help me with this...

Any help will be greatly appreciated. Thanks in advance.

[GilbertQ]

Hi @harishkola

Have you had a look as possibly using Q&A in your dashboard to filter for the data you are after?

Q&A is able to dynamically filter your data. So if you ask the question of Sales for Today, it will always show data for today.

Likewise you can do this for the past hour, last minute, last 10 minutes etc.

Here are all the different options: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-tips

[harishkola]

Thanks for the response @GilbertQ but in this case i don't want to use Q&A.. So if you know any other options please let me know.

[GilbertQ]

Hi there, if you have got a date/time column or a Date column, you can put it into the page filters and then use the relative date filter.

This will filter it to the current day at the lowest form.

I am not sure if this meets your exact requirement?