Reading Time: 6 minutes One of the conveniences of Tableau is the ability to easily create “running” totals or other aggregations. These table calculations can be handled through the user interface. One of the questions that I sometimes receive from Tableau users learning Power BI is how to create the equivalent of a Running Sum. As with most things…
Reading Time: 5 minutes The distribution of various charts and other objects on a canvas is a key part of creating meaningful data visualization. For anyone coming to Power BI from Tableau, what might they expect the experience to be when designing the basic layout of a dashboard (er…”report”)? In this post, I cover some of the key differences…
Reading Time: 3 minutes Continuing the series on “translating” Tableau to Power BI, let’s consider Tableau’s Viz in Tooltip. The versatile Viz in Tooltip allows authors to embed content from one or more sheets into the tooltip of another visualization. When hovering over a mark, a filtered view of the tooltip appears. The rough equivalent in Power BI is the Report…
Reading Time: 3 minutes A few months ago, I started a series of posts about “translating” Tableau functionality to Power BI functionality and terminology (FIXED LOD example). Continuing that series, one of the new features in Tableau 2018.3 is the concept of Set Actions, which allows users to build interactivity between sheets on a dashboard. Andy Cotgreave wrote a…
Reading Time: 4 minutes In Tableau, INCLUDE level of detail (LOD) expressions are used to obtain values for dimensions that are not directly used in a visualization. This final LOD post focuses on adapting Tableau INCLUDE LOD expressions to DAX in Power BI. See previous posts on FIXED and EXCLUDE as well. With FIXED, I used the counterpart ALLEXCEPT function…
Reading Time: 4 minutes In a recent post on Tableau level of detail (LOD) expressions, I explored a method to translate FIXED to DAX in Power BI. Continuing that theme, I’ll now attempt to show an equivalent for the EXCLUDE keyword. While EXCLUDE and INCLUDE are not as common as FIXED in my experience, I’ve started down the LOD…