Forum Discussion
Top N Filter in Power BI Service
Yes there are dates. I found a workaround,, by converting the dates into strings. I noticed that other types of values like numbers and strings work with Top N filter. It's not ideal but it's sufficient for now.
Thanks.
Hi murpoj
Thank you for the information. I think type of the dataset is the cause. Please reference this documentation: powerbi-service-real-time-streaming. And the bold words would be the reason.
>>>With a streaming dataset, data is also pushed into the Power BI service, with an important difference: Power BI only stores the data into a temporary cache, which quickly expires. The temporary cache is only used to display visuals which have some transient sense of history, such as a line chart that has a time window of one hour.
With a streaming dataset, there is no underlying database, so you cannot build report visuals using the data that flows in from the stream. As such, you cannot make use of report functionality such as filtering, custom visuals, and other report functions.
Best Regards!
Dale
Hi,
Sorry, I misnamed the type of data I'm using. It is a push dataset. I designed it to show realtime data from stream analytics. I can create report using this dataset, but this particular filter doesn't work.
Hi murpoj,
That's weird. I tested it successfully. Please check the dataset by creating a table visual. I noticed the axis is time. Are there any dates?
Best Regards!
Dale
Yes there are dates. I found a workaround,, by converting the dates into strings. I noticed that other types of values like numbers and strings work with Top N filter. It's not ideal but it's sufficient for now.
Thanks.