Top N filter issue (stream datasource)

[TransDig]

Hello,

I'm doing a report with a streaming data set (Stream analytics) with a "Timestamp" field of type Date. What I'm trying is to visualize into a graph only the last one row received.
To do this I use the top N filter provided by power bi. The problem is when I use it, the table doesn't show any value.

The table with all of the data:

With the Top N filter:

In the field "Show items" of the filter, if i put 10 or 100 items i have the same result.

I have performed the same test in power bi desktop with an import report and it works correctly.

Any ideas? 

Thank you all 

[Anonymous]

HI @TransDig,

I think this issue may related to live data, it will increase every time so topn filter can't find out correct value. If you stop push data to streaming dataset, does this filter works?

In addition, you can also try to add a measure to check current value to return tag, then apply this filter on visual level filter.

Measure:

Tag = 
VAR currDate =
    SELECTEDVALUE ( RealTimeData[Date] )
RETURN
    IF ( currDate = MAXX ( ALL ( RealTimeData ), [Date] ), "Y", "N" )

Regards,
Xiaoxin Sheng

[TransDig]

I tryed to stop push data to the datasource from stream analytics but I don´t see nothing in the table when I put the filtrer again.

On the other hand, I don´t know how I can do the measure because I´m working with power bi service. Is there any way to create a report using stream datasource with power bi desktop? 

Thanks for the reply Xiaoxin

[TransDig]

Anyone can help me to know any solution to take the last row recieved?

Thanks

[Anonymous]

Hi @TransDig,

In fact, your and my formula both works on my sample data. I'm not so sure why it not works.

Regards,

Xiaoxin Sheng

[TransDig]

Hi @v-shex-msft,

Thanks for your help. How I can do the measure:

Tag = 
VAR currDate =
    SELECTEDVALUE ( RealTimeData[Date] )
RETURN
    IF ( currDate = MAXX ( ALL ( RealTimeData ), [Date] ), "Y", "N" )

Because I´m working with power bi service. Is there any way to create a report using stream datasource with power bi desktop?

Regards