Top N Filter shows nothing

[DanielSuazo]

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.

[v-diye-msft]

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!

[mwegener]

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.

[mwegener]

Hi @DanielSuazo ,

it works for me too.

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

[nahid3152]

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