#Tabular editor format string code#

You should enter carefully – there is no IntelliSense in the tool! You can use the DAX Formatter button for safety – it will give you an error in the status bar if something went wrong. In the large field on the right we enter the expression SELECTEDMEASURE () – just do it, I’ll explain everything later. Right there we rename it (in my case, to “Sales”).

#Tabular editor format string code#

If you want to see over-optimized code and elegant solutions using calculation groups – you have a direct road to Italians 🙂 Fortunately, the latest Power BI updates give me the ability to finally answer them clearly and intelligibly. This article is just a try of a belated answer to numerous questions from colleagues and former students of my learning courses about the dynamic measure selection pattern. Note: I do not pretend to be a specialist in calculation groups.

Step by step, and with a description of possible pitfalls in unexpected places.Īs usual, the report is available for viewing here, and for downloading from here. Because now I’m going to show you how we can get our measures to format correctly. As a person whose main skill is data visualization, it drives me crazy. However, this method has at least one drawback: the formula changes dynamically, but its formatting does not. Agree, a very convenient thing – the user himself can choose what he wants to see: sales, conversion, the number of orders, or some terrible and infinitely important KPI that only 3.5 people understand in the whole company. The approach means users have no need to change the data on the external data source, prevents other users from reverse engineering confidential information, and masked values are able to retain dimensional identities.Many of you probably use one of the classic Power BI patterns – a dynamic selection of the measure displayed in the report. Leveraging Power Query, he randomized data during refresh. Gil Raviv, writing on DataChant, revisited a technique he last blogged about four years ago that involves masking confidential data in Power BI reports. It saves the users a lot of time trying to figure out if it is in the base currency or an alternate currency,' he wrote. Whilst this is a small fix, it is often critical when working with different currencies. 'It is always important to make sure that when creating a Power BI report, that it is easy for the users to read and explore their data. Plugging in the default values for the sales measure, he used double quotes to show where the DAX compiler runs. Quevalliers copied the Format String expression into DAX studio. Building on previous blogs about Calculation Groups, he used Tabular Editor 3, going into the Calculation Group navigating to Currency Symbol and Metric Currency.

Gilbert Quevalliers, writing on Four Moo, noted that he was recently working with customer data and discovered that a Calculation Group failed to return a Format String. Also, in case you missed it: check out our new interview with Microsoft MVP and Power BI consultant Matt Allington? Controlling default format strings with Power BI calculation groups Azure pros share their thoughts on calculation groups, confidential data, dataflows, and ADLS Gen2.