Friday, November 27, 2020

Creating PowerBI Up / Down Arrow

Sometimes you need a visual representation of when a value is up or down. I like to use a simple arrow as as shown below.

To do this, we can use the COMBINEVALUE DAX command with some simple conditional color formatting for the measure. In this example, I simply create a measure for the Percent Change of another value.

KPI % Change = COMBINEVALUES(" ", IF([Percent Change] <=0, unichar(9660),unichar(9650)), FORMAT([Percent Change],"#0.#%"))


If we simple want the icon, we can the omit the COMBINEVALUE DAX statement

% Change Icon = IF ([Percent Change] <=0, unichar(9660),unichar(9650))

No comments: