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

      • allwynbazil's avatar
        allwynbazil
        Helper I
        4 years ago

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

         

         

        Regards,

        Alwin