Font Awesome for empty cells

Questions & Answers
,
1

I am trying to update a current report that when cell is blank to insert Font Awesome Check mark and when the issue create is > 1 to enter a Font Awesome Circle.

I’m wondering is my script correct and what needs to be in the custom formatting field.

image
image1254×520 36.3 KB

2

Hi @ashrenee8301
To check if the measure is empty, you can use function isEmpty()
The formula would be this:

CASE WHEN
  IsEmpty([Measures].[Issues created])
THEN
  "<i class='far fa-check-square'></i>"
WHEN
  [Measures].[Issues created] > 0
THEN
  "<i class='far fa-circle'></i>"
END

In the report:

eazyBI_icons
eazyBI_icons1050×1002 102 KB

Also, see more information about markdown here: https://community.eazybi.com/t/measure-formatting-markdown-and-custom/

Best,
Gerda // support@eazyBI.com