Forum Discussion

dobregon's avatar
dobregon
Icon for Impactful Individual rankImpactful Individual
6 years ago

Top/Bottom N is not working

Hi guys,

 

I have a table in the database with thousands of events, with an identity/unique number for each event, id. In the PowerBI i have a table with the list of events with some metadata related to the event but as i want to have (in order to not upload many rows each time) is to filter the bottom 1000 events created (the last 1000 events).

 

So, i go to the filter visual ID, filter Botton N, 1000 and in by value i put the ID and it doesnt work and give me the 2000000000 events that i have.

 

am i doing something wrong? i have tried putting 1 in the bottom N and the result is always de same

Need Help

10 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi dobregon ,

     

    Like this?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • dobregon's avatar
      dobregon
      Icon for Impactful Individual rankImpactful Individual
      6 years ago

      hi Greg_Deckler it is a numeric value

      hi v-lionel-msft this is what i did but the visual doesnt filter anything, as you can see in my picture below i have put the eventid column, top N 1 using eventid and nothing happens

       

      The visual is configurated with the eventid only and the option "dont summarize" for that field becasue it is a numeric. The column is numeric 

       

       

      thanks in advance

      • dobregon's avatar
        dobregon
        Icon for Impactful Individual rankImpactful Individual
        6 years ago

        i have created the new column eventid2 as text and try to do the same and this solve the problem so it seems that needs to be text or something.

        waiting the confirmation of v-lionel-msft if i'm right to close the topic.

    • dobregon's avatar
      dobregon
      Icon for Impactful Individual rankImpactful Individual
      6 years ago

      hi again 

       

      Solved that problem i have found another problem. I have the lsit of events and each event has startdate and enddate and my dataset has a calendar of dates so, depends of the dates that i selected the events need to be filtered by the events that could have in that period.

       

      So, i have the list of events filtered first by a measure like "event active". The problem is that when i tried to apply the top 1000 event (in order to see the first 1000 events) the top 1000 events filter only the first 1000 events not taking into account the event active, it takes into account the whole list of events.

       

      is there any way that that filters are applyied after the applyied that event active?

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi dobregon ,

         

        "So, i have the list of events filtered first by a measure like "event active". The problem is that when i tried to apply the top 1000 event (in order to see the first 1000 events) the top 1000 events filter only the first 1000 events not taking into account the event active, it takes into account the whole list of events."

         

        Try to write all filters in DAX. In other words, directly make the measure return the result you want in the end, do not add "Filters on this visual."

        Do you mind sharing your .pbix file? (If the problem remains unresolved.)

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.