ms en ms fi fi fi ms fi fi fi fi fi ms hbs_lat ms sl ms fi fi fi ms ms fi fi it fi en fi fi en fi fi fi fi fi fi fi fi fi fi fi fi fi fi sq fi en fi fi fi fi fi eu fi fi fi de id fi fi fi fi fi fi fi fi fi fi fi fi fi tr fi fi fi ms en en it ru fi en en en en en en en en en en en en en en en en en en sco en en en en en en fr en ru ms en de en en fi fi fi fi fi fi fi fi fi fi fi fi fi fi ca en en id en en en en en en en en ms ms ms en en ml fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi en fi ms en en en fi vo fi fi fi fi fi ms sl fi fi en fi fi fi fi de fi fi id fi en fi fi sv fi fi fi hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko nb nl nl pl pt pt ru sv th tr zh zh ar he
Power BI Weekly Service Update | Microsoft Power BI – blogi | Microsoft Power BI
Office 365 + Power BI
In this week’s update we’ve added two new industry sample dashboards, reports and datasets as well as two new capabilities:  Friendly strings for hyperlinks and the initial version of Drill.
See what you can do with Power BI with two new Industry Related Samples
You have likely have seen and used the Retail Analysis Sample in the past, and we’re releasing two additional samples. The IT Spend Analysis industry sample dashboard and underlying report analyzes an IT departments planned vs. actual costs. You will be able to investigate where huge areas of deviations from the plan occurred. Here’s a screenshot of that dashboard:
The Supplier Quality Analysis industry sample concentrates on one of the most common supply chain challenges – supplier quality analysis. By exploring this sample, you can determine the best and worst suppliers and identify which plants are able to minimize downtime. Here’s a screenshot of that dashboard:
We’ll be adding a few more industry samples in the coming weeks so stay tuned to the blog!
There are times where you want to provide users with a link from a report to a specific location outside of Power BI. With today’s deployment we’ve added the ability to create a hyperlink on any text within a Text Box.  I start by adding a text box and typing the text I’d like my users to read.  Then, I select the text I’d like to add a hyperlink to. I then click the hyperlink icon and paste the URL I’d like the user to navigate to when they click on it. I’ve added a link to our Financial Sample support article on the “Hyperlinks” text.
Now, when the user is in Reading Mode they can click on the text and a new tab will be opened with the specified URL. Now, you can provide links for your users without needing to display the entire URL.
Drill Support in Power BI Reports
Now for the big announcement:  Drill!  With today’s update you can now create a Drill path that enables users to navigate from one level of data to related data that the report author has defined. I’ll be using the Financial Sample throughout so download it and follow along.  The excel workbook has some really great data that shows how effective the new Drill capability is in Power BI.  Here’s a quick screenshot of the excel workbook and data:
There are a number of fields that I’d like to have my report viewers be able to Drill up and down as they interact with the data.  The first ones are Product and Segment.  I’d like my users to be able to see the profit for a given product and then be able to drill down into related Segments for a specific product.  To accomplish this you simply need to drag both Product and Segment into the Axis list.  Remember, the order is important here. This defines the hierarchy of the drill.  I also added Profit as the value so that I can show how much Profit I’m making for each Product and Segment.
Normally, clicking on the Paseo column would filter this visual, and any others on this sheet, to only display data related to Paseo.  To enable Drill, and change the behavior of click, simply select the arrow icon in the upper right hand corner of the visual.  You’ll see the arrow change color to show it’s enabled. Once you click on this, you can now drill down into the Segments and the associated Profit for only the Paseo product.  Here’s what that looks like:
And, as you’ve guessed, you click on the arrow in the upper left corner to navigate back up to the initial Product view.
Finally, you’ll also see an icon with two down-arrows in the top left corner when you’re not at the bottom of the drill path:
When you click on this icon you will drill down to the next level but with all values displayed (Profit for all Products by Segment).
You can add more fields to the Axis if you have an even deeper Drill path that you’d like to create.  I’ve added Discount Band to this visual and drilled down through  Paseo and then Government.
Of course, all the normal capabilities of reports work with Drill.  I’ve created a richer report that provides me information about not only my profit as described above but also the number of Units Sold by Year and then Month (creating a Hierarchy with Year and Month) and then Profit and Discounts by Country. Here’s what the report looks like with the Low Discount Band selected and with the Units Sold by Year drilled down the Month:
And that’s the first view of Drill in Power BI.  As I noted above, this is the initial release for Drill and we’re looking for feedback on additional capabilities such as drill to details, drill-through etc. as well as on the user experience we have today.  Make sure to add your feedback to https://support.microsoft.com!
Follow @MSPowerBI on Twitter
Join the conversation at the Power BI Community
Tilaa Power BI -uutiskirje
Rekisteröidy alla, niin saat uusimmat Power BI -tiedot suoraan Saapuneet-kansioon.
Maa Afganistan Ahvenanmaa Alankomaat Albania Algeria Amerikan Samoa Andorra Angola Anguilla Antarktis Antigua ja Barbuda Argentiina Armenia Aruba Australia Azerbaidžan Bahamasaaret Bahrain Bangladesh Barbados Belgia Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia ja Hertsegovina Botswana Bouvet'nsaari Brasilia Brittiläinen Intian valtameren alue Brittiläiset Neitsytsaaret Brunei Bulgaria Burkina Faso Burundi Cabo Verde Caymansaaret Chile Cookinsaaret Costa Rica Côte d'Ivoire Curaçao Djibouti Dominica Dominikaaninen tasavalta Ecuador Egypti El Salvador Eritrea Espanja Etelä-Afrikka Etelä-Georgia ja Eteläiset Sandwichsaaret Etelä-Sudan Etiopia Falklandinsaaret Fidži Filippiinit Färsaaret Gabon Gambia Georgia Ghana Gibraltar Grenada Grönlanti Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard ja McDonaldinsaaret Honduras Hongkong, erityishallintoalue Huippuvuoret Indonesia Intia Iran Irlanti Islanti Israel Italia Itävalta Jamaika Jan Mayen Japani Jemen Jerseyn voutikunta Jordania Joulusaari Kambodža Kamerun Kanada Kazakstan Kenia Keski-Afrikan tasavalta Kiina Kirgisia Kiribati Kolumbia Komorit Kongo Kongon demokraattinen tasavalta Kookossaaret Korean tasavalta Kosovo Kreikka Kroatia Kuwait Kypros Laos Latvia Lesotho Libanon Liberia Liechtenstein Liettua Luxemburg Macao, erityishallintoalue Madagaskar Malawi Malediivit Malesia Mali Malta Mansaari Marokko Marshallinsaaret Martinique Mauritania Mauritius Mayotte Meksiko Mikronesia Moldova Monaco Mongolia Montenegro Montserrat Mosambik Namibia Nauru Nepal Nicaragua Niger Nigeria Niue Norfolkinsaari Norja Oman Pakistan Palau Palestiinalaishallinto Panama Papua-Uusi-Guinea Paraguay Peru Pitcairn Pohjois-Makedonia Pohjois-Mariaanit Portugali Puerto Rico Puola Päiväntasaajan Guinea Qatar Ranska Ranskan eteläiset alueet Ranskan Guayana Ranskan Polynesia Réunion Romania Ruanda Ruotsi Saba Saint Barthélemy Saint Kitts ja Nevis Saint Lucia Saint Martin Saint Vincent ja Grenadiinit Saint-Pierre ja Miquelon Saksa Salomonsaaret Sambia Samoa San Marino São Tomé ja Príncipe Saudi-Arabia Senegal Serbia Seychellit Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakia Slovenia Somalia Sri Lanka St. Helena, Ascension, Tristan da Cunha Sudan Suomi Suriname Swazimaa Sveitsi Syyria Tadžikistan Taiwan Tansania Tanska Thaimaa Timor-Leste Togo Tokelau Tonga Trinidad ja Tobago Tšad Tšekin tasavalta Tunisia Turkki Turkmenistan Turks- ja Caicossaaret Tuvalu Uganda Ukraina Unkari Uruguay Uusi-Kaledonia Uusi-Seelanti Uzbekistan Wallis ja Futuna Vanuatu Vatikaanivaltio Venezuela Vietnam Viro Yhdistyneet arabiemiirikunnat Yhdistynyt kuningaskunta Yhdysvallat Yhdysvaltain Neitsytsaaret Yhdysvaltain pienet erillissaaret Zimbabwe
Haluan saada seuraavan Power BI -uutiskirjeen. Tietosuojatiedot.
Osallistuminen edellyttää henkilökohtaisten tietojesi siirtämistä muihin maihin, joissa Microsoft toimii, muun muassa Yhdysvaltoihin. Lähettämällä tämän lomakkeen suostut tietojesi siirtämiseen Kiinan ulkopuolelle. Tietosuojalauseke.
Mikä on Power BI?
Power BI on yritysanalytiikan työkalupaketti tietojen analysointiin ja merkityksellisten tietojen jakamiseen. Seuraa liiketoimintaa ja hanki nopeasti vastauksia monipuolisista raporttinäkymistä, joita voi käyttää kaikissa laitteissa.
Hanki viimeisimmät uutiset Power BI -blogista
Tilaa sähköpostitse Sinun on annettava kelvollinen sähköpostiosoite Olet antanut henkilökohtaisen sähköpostiosoitteen. Anna työpaikan tai oppilaitoksen sähköpostiosoite. Tapahtui virhe. Yritä myöhemmin uudelleen.
Näytä kaikki ladattavat tiedostot