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…
Read MoreMonth: February 2018
Introducing “R DataTable” Custom Visual for Power BI
Reading Time: 3 minutes Back in July 2017, I experimented with interactive R HTML custom visuals in Power BI and created a simple table visual that I called R DataTable. I had originally submitted it to AppSource in October. After…
Read More
Tableau to Power BI: FIXED LOD Expressions
Reading Time: 3 minutes Every once in awhile, I encounter questions from a trainee or client who is familiar with Tableau but who is getting started with Power BI. They have the ability to do X in Tableau and want…
Read More
Unpivoting Sensitive Columns in Power BI to Apply Row-Level Security
Reading Time: 3 minutes In my last post, I explored a less-than-ideal way to approach the lack of object-level security in Power BI. That workaround used DAX to mask sensitive values for certain users. Since that method is not a…
Read More
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…
Read More