Forum Discussion

DanielSuazo's avatar
DanielSuazo
Regular Visitor
6 years ago

Top N Filter shows nothing

Hi, I have a problem filtering by Top N a datetime column from a streaming dataset (with historic data analysis on). 

I got this column:

 

and I want to filter the column 'hora_fecha' by latest 'hora_fecha', for example, top 3, but when i do that, it doesn't get any value shown:

 

 

I get this problem using Power BI in web or desktop.

Also, this is a test dataset, i did this filter without a problem in another report and trying to replicate that in a new dataset I got into this problem.

 

Thanks in advance,

Daniel.

Need Help

4 Replies

  • nahid3152's avatar
    nahid3152
    Helper II
    6 years ago
    Hi,DanielSuazo
    You solve it by doing 3 steps
    1. TOTAL= Sum(table[value])
    2. Top Rank = rankx(ALLSELECTED('Table'[hora_fecha]),[Total Plot Value],,Desc)
    3. User filter pane Top Rank
  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi DanielSuazo ,

     

    it works for me too.

    Can you provide some information about the settings in your realtime dataset?

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi DanielSuazo 


    is your problem solved?

    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi DanielSuazo 

     

    Any updates on this post?

    If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!