Status Icons in Power BI Tables


Have had a couple of requests for people asking how to have Icons instead of the Measure actual values in a Power BI Table.  While this isn’t available directly in PowerBI one of our MVPs wrote a great blog post on how to do this with R.

http://sqlkover.com/dynamically-changing-shapes-in-power-bi/

Turns out you can also get some of this functional using a little DAX.

The first step is to add a new column (see below)

image

In that new column you need to decide when (what value) you want to show the up versus the down.   While this example I am only showing two arrows i could have nested the “IF” statement to display other arrows.

In the example below I am using a second column and performing some math on it.

stoplight = IF([Revenue] < [Units] * 2000, "▼", "▲") & " " & FORMAT([Revenue],"####.##")

 

Which will give me the following table…..

image


Comments (0)

Skip to main content