Unichar if value = 1

[Anonymous]

Hi,

Probably super noob question but here we go.

I have a matrix:

These values are based on rows, not measures. So I was thinking to use unichar to show green for 1 og nothing for 0. But am I not allowed to look for 1 and 0 in rows? when I use IF I only get measures as suggestions.

Can someone point me in the right direction? 🙂 Thanks!

[jdbuchanan71]

Hello @Anonymous 

You can apply conditional formatting based on the max of the field to get what you are looking for.

[Anonymous]

hi @jdbuchanan71, 

I was investigating that as well, but I don't have the option to use conditional formatting. Seems like it's only if you use values?

So it's not available ince I only use rows.

[jdbuchanan71]

Can you switch it from a matrix to a table and still get the visulization you need since you are only using rows?

[Anonymous]

@jdbuchanan71to easy!

Works like a charm now!

Do you know if there is a way to only show the icon, and not both?

[jdbuchanan71 · Accepted solution]

Under Icon layout you can select "Icon only"

[Anonymous]

@jdbuchanan71ah, thanks. that was simple as well 🙂

but now I remember what my problem was with using a table though. The names of "contact keep repeating itself

But with matrix is shows like this:

Any way to achive the same with a table?

[jdbuchanan71]

You will have to write a measure to calcluate the amount you are trying to show under Sale.  It should be as easy as

Sale Amount = MAX ( Sale )

because you are showing the value for every row.  Then you put that measure in the value section where you can format it.

[Anonymous]

@jdbuchanan71Not sure if I understood you correctly. Like when you turn stepped layout off on matrix.

if I select max(contact) I still get one line pr entry.

I want:

Contact:

 - candidate 1

- candidate 2

- candidate 3

Like in the picture I sent 🙂

[jdbuchanan71]

No, you change your view back to a matrix and put Sale in the values section.

[Anonymous]

ah, yes that worked. Think I tried that before and it didn't work, but then I did something wrong. 

Thanks a lot @jdbuchanan71 

---