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:
Post a Comment