CODEWITHSUNDEEP
dynamicpowerbitableau-apitiles
Vin
Vin

Reputation: 1

Power BI - Dynamically change position and size of tiles in a time interval

Please check attached image Layout

In Power BI or Tableau want to create a dashboard will have 5 tiles.

4 small tiles in corners and one big tile in center.

Want to Dynamically bring each small tile to the center in a particular time interval say every 2mins.

Data in each of these tiles will be dynamically updated each business day morning.

This will be displayed in a big LED panel.

Upvotes: 0

Views: 1853

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

You can't rearrange the position of the visuals in a report, but you can make a report with 5 pages, where each visual has a page, where it is "on focus" and cycle through these pages.

The cycling can be done in different ways:

  1. Use Presentation mode on Windows 10 app.
  2. Publish the report to Power BI Service and use Tab Rotate Chrome plugin (or similar solution, which I'm pretty sure exists for other browsers) and show different pages opened in 5 browser tabs.
  3. Publish the report to Power BI Service, embed it in your application, and programatically cycle through it's pages.
  4. Pin tiles for Streaming datasets in 5 dashboards and push data to them (see Real-time streaming in Power BI and Push data to Power BI streaming datasets without writing any code using Microsoft Flow).

Automatic data refresh depends on the storage mode of your report - is the data imported or you are using DirectQuery mode. If you publish an imported dataset to Power BI Service, you can schedule automatic refresh. For DirectQuery, either in Power BI Desktop or Power BI Service, you can use Automatic page refresh.

I will also recommend you to take a look at Data refresh in Power BI article.

Upvotes: 1

Related Questions