Power Bi March Update

2 days ago Microsoft just released another monthly update of Power BI Desktop. They introduce following Update:

Visualization:

  • Ability to publish reports to a Group Space in Power BI Service, permit user to creare and publish report only for specific members of workspace.
  • Reports respect Do Not Summarize model setting from SSAS MD. Power BI respect the SSAS property IsAggregatable.

Continua a leggere

Annunci

Power BI on Apple Watch

Microsoft have realeased on 25th March a new power bi app for Apple Watch. That permit to access your critical information and insights directly from the watch face without opening the Power BI app itself.

When you open the Power BI app for Apple Watch, you will see an Index screen with a quick overview of all applicable tiles from the synced dashboard. Keep a close eye on your most important metrics. You can drill into a specific tile by tapping on it to get more data:

38367167-b177-463c-865a-0a7a275d909c

To sync a Power BI dashboard to your Apple Watch, first open the Power BI app on your phone, load a dashboard, and tap the dashboard actions menu. Next, open the Power BI app from the Apple Watch springboard.

Download now the app : Power BI App

Connect 2 Pivot table with a Symple Filter

Sometimes when on excel you want to filter data in a pivot table you can’t use a slicer but you have to us a filter. For example when you have :

  • A long list of data (100/200 customer for example)
  • Different type of data
  • Long Description

In these cases you prefer to use a classic filter for use search query to improve your filtering. But Filters works only with one pivot table and it isn’t possible to use same filter to connect two table. For Example we start from this situatio:

Immagine 020

We want to Filter data by project but this attribute have long words and many rows ( 200 different project) but we don’t want to repeat our filter. To solve this problem we have to do one simple thing : create a slicer. IN particular:

  1. Create a new slicer connected to the first pivot table. the slicer have to refer the same attribute that we want to filter, in our case Project.

Immagine 021.png

2. After that we connect the slicer to the second pivot table and we remove the second filter:

Immagine 022.png

At this point we can hide the slicer and use only the filter. if you have done all the passages correctly the filter of first pivot table should filter the second one.

This solution can be repeated with 2 or more filters.