Forum Discussion

allwynbazil's avatar
allwynbazil
Helper I
4 years ago

Latest data from the SharePoint list

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

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

 

allwynbazil's avatar
allwynbazil
Helper I
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      allwynbazil
      Helper I
      4 years ago

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

       

       

       

      • PowerBIOrg's avatar
        PowerBIOrg
        Resolver II
        4 years ago

        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.