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…