Archive for April, 2017

The DAX Unichar() Function And How To Use It In Measures For Data Visualisation

April 12, 2017 Leave a comment

Great! One of my favorite feature in Tableau is now available in Power BI.

Chris Webb's BI Blog

A few weeks ago I was asked whether it was possible to display line breaks in text in a Power BI visualisation. It turns out it isn’t possible – at the moment Power BI always strips line breaks out of text when it gets loaded into the Data Model. However while researching this I came across the DAX Unichar() function, which returns the unicode character associated with an integer value – and which also seems to be completely undocumented for some reason, I guess because it’s new (it isn’t in Excel 2016 DAX yet as far as I can see).

It’s very straightforward to use: for example, the DAX expression UNICHAR(65) returns the character A; see here for a list of unicode characters and their associated codes. You can have a lot of fun with this function in Power BI when you use it to return symbols that in turn…

View original post 271 more words

Categories: BI