cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harishkola Frequent Visitor
Frequent Visitor

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

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.

3 REPLIES 3
Super User
Super User

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

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


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
harishkola Frequent Visitor
Frequent Visitor

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

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.

Highlighted
Super User
Super User

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

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?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 31 members 852 guests
Please welcome our newest community members: