Working with comma-separated values (CSV) in DAX

There are instances where you get a comma-separated list of keys in each row of a table, and you need to replace it with lookup values. This blog post shows two ways of addressing this situation in DAX. But first, why would you want to do it in DAX? Continue reading “Working with comma-separated values (CSV) in DAX”

Combo charts with no lines in Power BI

At the moment, Power BI has two visuals that support two Y axes: the line and stacked column chart, and the line and clustered column chart. In the May 2018 release of Power BI Desktop, there is going to be an important enhancement to these charts (as well as the various line visuals): we will be able to set the line stroke width to zero (this can already be done in Power BI service). In this blog post, I am going to show two use cases for it. Continue reading “Combo charts with no lines in Power BI”