How to create Dynamic Format Strings for Measures ? | Microsoft Power BI | Simple and easy example

Описание: *** Source : From Microsoft Power BI Documentation ***


Follow these steps to create a dynamic format string:
1) In the Data pane, select the measure for which you want to specify a
dynamic format string.

2) In the Measure tools ribbon , Formatting section , Format listbox, select
Dynamic. A new listbox with Format already selected appears to the left of
the DAX formula bar. This drop down is how you can switch between the
static measure DAX expression and the dynamic format string DAX
expression. Whatever the static format string was in use before switching
to Dynamic is prepopulated as a string in the DAX formula bar.

3) Overwrite the string with a DAX expression that outputs the correct
format string for your measure.

Here is the Pseudo code for Dynamic format string # of units sold measure

SWITCH(
TRUE(),
SELECTEDVALUE(Sales[Item Type]) IN { "Office Supplies","Personal Care","Household"}, "#,0 Units ",
SELECTEDVALUE('Sales[Item Type]) = "Beverages","#,0 Liters",
**************** "additional Dax code goes here **************"
)