topic Re: Dynamic dashboard in Developer

Dynamic dashboard

Naama1 — Tue, 09 Oct 2018 12:30:53 GMT

Hi,
I wanted to know if there is a possibility to build a dynamic dashboard- that is, dashboard that changes without the click of a button and runs independently?
for example- I have a risk table that is filtered by a slicer according to the project which the risk is associated .

I am interested in creating a dashboard in which risks will be presented for only one project at a time, and every few seconds the project will be replaced by the risks automatically.

Thanks,

Naama

Re: Dynamic dashboard

Greg_Deckler — Tue, 09 Oct 2018 13:40:25 GMT

I am not aware of any way to do what you are asking. There might be a way to do it via third-party tools. I would think that you would want to start by creating bookmarks for each project and then find a way to iterate through those bookmarks. That would only work in a report and not an actual dashboard but I'm assuming you are using the word dashboard rather loosely here.

Re: Dynamic dashboard

TedPattison — Tue, 09 Oct 2018 22:25:10 GMT

I have developed custom applications that acheive this effect with Power BI embedding. The solution builds on what Greg suggests which is to create a set of bookmarks for each of the views you want to display in the report. Then you must use custom development (ouch!) to embed the report on a web page in a custom application. The trick is to create a JavaScript timer which executes client-side code that navigates the report from one bookmark to the next. I usually set the timer to an interval between 3-5 second and that creates a carousel-effect of rotating between views as the report navigates between bookmarks. And yes, the user can just sit back and watch.

Unfortunately, I don't think this techniquie is available unless you are willing to drop down into developer-level details. Upon request, I would be happy to send you a code sample of JavaScript code I wrote to acheive this effect. using the Power BI JavaScript API.