THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Power BI   (RSS)
Showing page 2 of 7 (65 total posts)
  • BI Beginner: Stacked Charts in Power BI

    People new to Power BI Desktop have asked me how to create a columnar chart where each column has different colors for different values stacked on top of each other. There’s no reason to be intimidated. Creating such a chart is very simple with only two additional requirements since yesterday’s port. First, your input data must classify the data ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 18, 2017
  • BI Beginner: Simple X-Y Plot

    When I worked for Microsoft giving presentations on data platform products, it was a common occurrence to have people tell me that they didn’t know how to use Power BI. This is the first in a series of posts showing how to do simple, useful tasks in Power BI Desktop. Power BI Desktop is free. Download the Power BI Desktop from here. You can ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 17, 2017
  • The new data modeling book for Power BI and Power Pivot users

    In the last few years, I and Alberto Ferrari assisted many users of Power Pivot and Power BI who wanted to create their reports using these tools and were struggling with getting the desired numbers from their data. The first approach of an Excel user is to look for a function, or a more complex DAX expression, that can implement the calculation ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 7, 2017
  • Avoid measure and column with the same name in #dax

    I recently wrote an article about duplicated names in DAX to highlight a possible case where you can have a measure with the same name of a column. This is not a good idea, mainly because the syntax to reference a measure and a column is identical, and this similarity is the root of a number of issues. It would be much better if the measure ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 2, 2017
  • Using and optimizing DirectQuery in #powerbi and #ssas #tabular

    More than one year ago, I and Alberto Ferrari started to work on DirectQuery, exploring the new implementation appeared in Analysis Services 2016 for the Tabular models, which uses the same engine of Power BI. The previous version of DirectQuery appeared in SSAS Tabular 2012 was very slow and suffered of performance issues also using small models. ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 19, 2017
  • PASS Business Analytics Marathon (March 2017) - Recordings Available!

    The sessions of the event PASS Business Analytics Marathon, held last March 2017 on 29th, were recorded and now they are available for online streaming! If you have missed one session in particular or the entire event, you can view or review your preferred topics. Each video is available on detail page of the related session, you can find the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on April 14, 2017
  • PASS Business Analytics Marathon (March 2017)

    The next edition of the live event PASS Business Analytics Marathon will be on March 29, 2017. This edition of Business Analytics Marathon will consist of five webinars on the following topics:Data Driven StorytellingData DiscoveryPower BIThe schedule is available here. Thanks to the Sponsors, the event will be free of charge, register ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 24, 2017
  • Unexpected side effects of table filters in #dax

    One of the side effects that you might not expect from a table filter in a CALCULATE statement is the removal of an existing filter. In reality, this is a condition that happens when you write an explicit CALCULATE in a row context, because the table filter overrides the context transition in case you filter the same table that generated the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 21, 2017
  • New syntax in DAX: IN operator, table and row constructors #dax #powerbi

    I recently wrote an article to described in more details the syntax of the IN operator in DAX, which is available in Power BI and in the CTP of the next release of Analysis Services. Jeffrey Wang wrote a blog post about the IN operator a few months ago, so I waited some time to include more details about how it internally works ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2017
  • Mark as Date table in Power BI #dax #powerbi

    One year ago I wrote an article describing how the time intelligence DAX functions work in Power BI (I just updated the article including the example described below). In a recent event in Sydney I observed a strange (or at least unexpected) behavior of Power BI during a demo, and I think it is interesting to share a few considerations ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 21, 2017
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement