Latest data from the SharePoint list

Question

Hi Team,&nbsp;This is regarding the post belowhttps://community.powerbi.com/t5/Desktop/Show-only-data-from-the-latest-date/m-p/442889I am new to PowerBI and have tried the accepted solution in the post above. However, I don't understand how to set the visual filter as 1. I am trying to pull the value from the 'Progress' column for the latest date(in Date column). Please help me.&nbsp;&nbsp;Regards,Alwin

anonymous · Answer

Hi,Does the filter not work properly if you set the visual level filter to "Is" 1?&nbsp;

allwynbazil · Answer

Thanks for your quick reply. I don't have an option for Is 1, as in your image. Please let me know what am I doing wrong. I can see only Is(All) there.&nbsp;&nbsp;

anonymous · Answer

Hi,Try expanding (clicking) where it currently says "is less than" for you and you should get a list where you could change it to "is" like this picture:You then have to manually enter a 1 in the box like this:&nbsp;&nbsp;

allwynbazil · Answer

Unfortunately, it's not giving me the option there as, well. There is no drop down.&nbsp;&nbsp;&nbsp;

anonymous · Answer

Okay,Let's try if this work-around works:Drag the date column into the visual filters and use that to find the lates value.&nbsp;&nbsp;

Forum Discussion

Latest data from the SharePoint list

10 Replies

Related content

Extract Data from sharepoint

Sharepoint Data with Oracle Data

Sharepoint list mirroring

Dataset autorefreshed but not the latest data?

Incremental refresh of only latest file from sharepoint / local desktop folder