topic Re: Filtering in real time dashboard. in Developer

Filtering in real time dashboard.

AlexL — Wed, 28 Dec 2016 13:31:47 GMT

Hello!

I created real time dashboard (Line Chart) and show current price for each product order by time.

I push data in API. Data has next format:

[
{
"ProductName" :"AAAAA555555",
"CurrentPrice" :98.6,
"SentTime" :"2016-12-28T13:12:50.830Z"
}
]

Values - CurrentPrice
Legend - ProductName
Axis - SentTime

Can I filter showed values by ProductName (select ProductName and show values only for a selected ProductName)?

Re: Filtering in real time dashboard.

tringuyenminh92 — Wed, 28 Dec 2016 13:59:33 GMT

Hi @AlexL,

Are you using real-time streaming in Power BI Service?

Re: Filtering in real time dashboard.

AlexL — Wed, 28 Dec 2016 14:23:34 GMT

I am adding streaming dataset in my web version of Power BI and pushing data in Power BI API from my own web app.

Re: Filtering in real time dashboard.

tringuyenminh92 — Wed, 28 Dec 2016 14:29:55 GMT

Hi @AlexL,

In PBI Service, you could to its Reports -> add slicer of products-> choose product you want -> pin line chart filtered. It will work.

Re: Filtering in real time dashboard.

AlexL — Wed, 28 Dec 2016 14:48:38 GMT

How can I get all products for slicer? I am pushing data in streaming dataset.

Re: Filtering in real time dashboard.

tringuyenminh92 — Wed, 28 Dec 2016 15:08:50 GMT

Hi @AlexL,

Uncheck all filters, so you could have all products, then pin it. (when you create stream dataset, dataset will be genereated in PBI service and you could design report in Reports area)

Re: Filtering in real time dashboard.

Eric_Zhang — Fri, 30 Dec 2016 09:20:36 GMT

@tringuyenminh92 wrote:

Hi @AlexL,

Uncheck all filters, so you could have all products, then pin it. (when you create stream dataset, dataset will be genereated in PBI service and you could design report in Reports area)

@tringuyenminh92

The stream dataset is not like the normal ones, I don't find any report design page for it. AFAIK, we can only add a tile using the stream dataset from a dashboard.

@AlexL

There's no such filter for real-time tile, you can submit and vote up your idea at Power BI Ideas.

Re: Filtering in real time dashboard.

tringuyenminh92 — Fri, 30 Dec 2016 09:41:23 GMT

Hi @Eric_Zhang, sorry to say that you are not correct. I will show report page that created from stream dataset when I back home ^_^

Re: Filtering in real time dashboard.

tringuyenminh92 — Fri, 30 Dec 2016 11:29:20 GMT

Hi @Eric_Zhang,

Go to Stream data setting, in Action area, there will be a "Create Report" option. This is the reason that i support idea DAX in PBI service cause i could not get the latest row and ignore another one.

@AlexL in real-time dashboard created by stream dataset, i think we could not handle filter data cause it's not supporting DAX so far, so please support us by voting above idea.

Re: Filtering in real time dashboard.

AlexL — Tue, 03 Jan 2017 13:12:03 GMT

Hi, @tringuyenminh92.

I created report from streaming dataset. For slicer i can only pin live page, not pin for slicer. Also slicer is empty in the report and in the dasboard although the data comes and historical data is on.

In Report

In Dashboard

Re: Filtering in real time dashboard.

tringuyenminh92 — Tue, 03 Jan 2017 14:17:21 GMT

Hi @AlexL,

You are correct, you could not pin slicer to dashboard and just pin live page or filtered chart to dashboard. But it's so strange when there is no data showing in your report.

Re: Filtering in real time dashboard.

AlexL — Tue, 03 Jan 2017 15:05:43 GMT

@tringuyenminh92, Are you use Pro version of Power BI?

Re: Filtering in real time dashboard.

tringuyenminh92 — Tue, 03 Jan 2017 15:38:41 GMT

@AlexL

Yup @AlexL, I'm using Pro lic.