Is there any way to highlight Boolean formatted or Text formatted metric using Conditional Formatting ?
Best answer by Elliot 27 June 2022, 22:32
Hi Susmita, at the moment conditional formatting is only available for numbers, or, empty/not empty cells. However, this is in our roadmap so please stay tuned while our team works on it :)
Hi SusmitaGood question! As @Tess.Hunt said conditional formatting is for numbers or empty/not empty cells. This means you can’t do conditional formatting on text formatted metrics, but you CAN do it on Boolean formatted metrics using empty/non empty.
Regarding text formatted properties, you are unable to use conditional formatting, however, you might be able to leverage Emojis in dimension items to achieve the same result.For example, see below.
The indicator column is a metric within a table. You can then use a formula to show different emojis depending on what condition you want to set. I’ve only done this a couple of times, but, it’s a powerful work around.If you let me know the context of what youre trying to achieve I can advise on what options we have available.
Thank You, appreciate your help so much..!!
I am trying to highlight Version Status Column, if my status is open is should show red and if it is locked then green.
It would be great help if you could help me with how to use Emojis in dimension items.
Hi @Susmita ,
Here’s a short walk through of turning a boolean metric in a status using a dimension and emojis.
The steps are the following:
IF('Boolean by City', 'Boolean Status'."✅", IF(NOT 'Boolean by City', 'Boolean Status'."❌", 'Boolean Status'."🤷"))
Please let me know if this helps!
Thank you so much for the detailed and clear response..!!
Don't be shy - let the Community help.
Already have an account? Login
Single Sign-On Need help?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.