Limit number of records in graph (data from IoT Hub)

[Andy_M]

Hi,

I'm trying to limit the number of records that my graph in PowerBI Service displays.

My current graph looks like this:

The graph (added to dashboard) auto-updates when new data from IoT Hub arrives.

But I would like it to get rid of the old data (always showing e.g. the 10 latest records).

Is there a filter/option to show only the 10 latest data records that arrive from IoT Hub?

(I'm aware of the filter that allows me to choose all data that arrived after a certain date / time.

But this would have to be updated manually all the time which is not what I want to do...)

Your help would be greatly appreciated.

[v-ljerr-msft]

Hi @Andy_M,

A new filter type called "Top N" for visual level filters has been added with the latest version of Power BI Desktop(2.40.4554.463 64-bit (October 2016)), which should meet your requirement in this scenario. For more detail about this, please refer to "Top N filter".

Regards

[Andy_M]

Hi @v-ljerr-msft

thank you for your suggestion.

Unfortunately the "Top N" filter does not work with my current dataset. I can use it on "timecreated". "By value" "value" gives me the top (or bottom) values, which is not what I want. So I tried to use it "By value" "count of timecreated":

(There is no option for me to choose "timecreated". I can only choose "count of timecreated".)

Looking at the example you posted, I pondered inserting a "total units" count into my dataset. But let´s assume the whole thing runs for a month and data is streamed continuously: That would give me an unreadonably large "total units" number over time...

It would be perfect if I could just filter "By value" "timecreated" in the "Top N" filter.

[v-ljerr-msft · Accepted solution]

Hi @Andy_M,

What's the data type of the "timecreated" column? Is it possible for you to convert the "timecreated" column to number type, or add a new number column which can be identified as "timecreated"? Then you should be able to use the number type column of "timecreated" within "By value" field of the "TopN" filter.

Regards

[Andy_M]

Hi @v-ljerr-msft,

I started implementing your idea when PowerBI changed the status of my dataset from Stream Analytics from "Dataset" to "Streaming Dataset". Working with "Streaming Datasets" is different from the work with "Datasets" and I am currently trying to get a handle on that. So unfortunately I am unable to verify whether your solution solves the problem.

Thank you for your help