Manual DAX Bins - DataVeld

Manual Groups and Bins in Power BI: Why and How

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

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

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

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…

Building Horizon Graphs in Power BI

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…