Latest data from the SharePoint list

[allwynbazil]

Hi Team,

This is regarding the post below

https://community.powerbi.com/t5/Desktop/Show-only-data-from-the-latest-date/m-p/442889

I 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.

Regards,

Alwin

[Anonymous]

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. 

[allwynbazil]

The by Value column is not an editable one. I am not sure why these fields are not responding.

[Anonymous]

You would have to actually drag the date column into the box.

[allwynbazil]

Do you mean dragging the Date column to the Progress Box? I tried there is no change.

Can you give me the screenshot please.?

[Anonymous]

Hi,

Does the filter not work properly if you set the visual level filter to "Is" 1?

[allwynbazil]

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.

[Anonymous]

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:

[allwynbazil]

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

[PowerBIOrg]

Hi, 

Maybe you can try the following steps:

1. Change your visual from Card to Table 

2. Ensure 'Progress' and 'Measure' in the Table

3. Set the 'Measure' field to 1 in Visual Level Filters

4. Remove 'Measure' field from Table, but keep in Visual Level Filters.

5. Change back from Table to Card.

Regards.

[allwynbazil]

it's the same for Table as well. There is no drop down options.

Regards,

Alwin