Manual DAX Bins - DataVeld

Manual Groups and Bins in Power BI: Why and How

Reading Time: 6 minutes When needed, Power BI offers the ability to create Groups and Bins to help consolidate data into a more presentable or meaningful visualization. The documentation has more detail and walks through the process of creating Groups and Bins. Looking at Bins and Groups in a Power BI model using a tool like SQL Server Management…

Tableau INCLUDE LOD for Power BI DAX - DataVeld

Tableau to Power BI: INCLUDE Level of Detail Expressions

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…

Masking Measure Values in Analysis Services and Power BI

Reading Time: 4 minutes Object-level security is one of the significant new features introduced for SQL Server Analysis Services 2017 and Azure Analysis Services. With object-level security, you have row-level security and add the ability to lock down tables and columns so that users are unaware of their existence. Table-level security, column-level security, and row-level security can be used…

Using DAX to Normalize Data in Power BI

Reading Time: 2 minutes A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon chart and Slopegraph in Power BI without the use of custom visuals. In many cases, we can use DAX, selective filtering, or other tricks to…

Throwing a Curve at the Power BI Line Chart

Reading Time: 6 minutes Last month, I explored how to take a Power BI area chart and make it into a unique “new” chart type using only data and DAX formulas. The line chart is also a candidate for a bit more flare. How can we go from a bland line chart… …to a more attractive, curved slopegraph? Many…

Building Horizon Graphs in Power BI

Reading Time: 5 minutes Horizon graphs are an intriguing but initially confusing way of looking at time series. Once you get familiar with the layout, you can simply think of it as a more space-efficient way of rendering a common line or area chart. Where there is a broad range in the data from low values to high values, horizon graphs condense…