Formatting code is often a pain, indenting lines, trying to align stuff etc. But not with Microsoft Dynamics 365 Business Central and AL in Visual Studio Code. Now you can just do “format document” ?
Tag Archives: Format
Colour Names Supported In Power BI Conditional Formatting
When I read about the new conditional formatting by values feature in the August 2018 release of Power BI Desktop, my first thought was to write a blog post on how DAX can be used to generate the hex values for colours – but then Daniil Masyluk wrote an excellent post on that (and more) yesterday.
Formatting Data to Create an Issue-Free Report in Power BI
Microsoft Power BI is an amazing tool. It allows me to build reports that update with real-time information from our ERP system, Microsoft Dynamics NAV, so that all of our team members can access information about financials, projects, cash flow, and various statistics in one click. However, Power BI is anything but perfect, especially when it comes to formatting.
Power BI, SSAS Multidimensional And Dynamic Format Strings
If you’re building reports in Power BI against SSAS Multidimensional cubes then you may have encountered situations where the formatting on your measures disappears. For example, take a very simple SSAS Multidimensional cube with a single measure called Sales Amount whose FormatString property is set in SSDT to display values with a £ sign:
Multilanguage across Conflicting Text Encoding Formats
To support users with translated strings across conflicting text encoding formats, you must save the translations to a text file in UTF-8 text encoding format.
The Text.Format() Function In Power BI/Power Query M
New functions are appearing in M all the time, many with no announcement or documentation. I came across Text.Format() the other day and I thought it was worth blogging about because I can see a lot of uses for it: it makes it very easy to insert values into a piece of text.
Dynamics NAV Date-time format with SOAP and XML Ports
When developing in dynamics NAV I cam across an annoying issues when trying to run an XML port through the SOAP service. The application was a build server that would, after importing and re-compiling all new objects, run XML ports with new updated data.