Help with conditional formatting arrows for KPI

[Anonymous]

Hey forum!

I am trying to create an arrow KPI with conditional formatting for a matrix, but for some reason, I can't figure it out.

The rules are very simple, but i cannot get it to fit with the conditional formatting rules.

"When percentage is above 0, display up green arrow, when percentage is below 0, display a red down arrow"

The problem is that conditional formatting, cannot go above 100% - but growth can easily exceed 100%. 

What can i do in order to achieve it?

[Anonymous]

Is there a way to see the pixels of it, like when you make a cell bigger in excel. 

Now that i have enlarge a single cell, i need to make sure all my cells are the same, but i cannot see pixels when dragging the cell bigger. So i don't know how much to drag the other cells.

Are there a quick way, to make sure all cells are same size in a matrix?

[MFelix]

Hi @Anonymous ,

No you cannot define it with values of pixels only manually. What I ussually do when I want to assure that the size is the same is to have a rectangle on top and increasing the row size at that size, then moving to the next column and resizing. Just one thing be sure to turn off the auto size  off

It's a stupid work around but nothing better now.

[Anonymous]

Thank you. 

[Anonymous]

How do i expand the cell, so percentage is shown besides the number and not below it.

[MFelix]

Hi @Anonymous ,

On the header of the column if you do an hover you should see a change in the mouse icon thar allows you to expand the column (just like in excel) then you can use the double click or drag and drop.

[MFelix · Accepted solution]

Hi @Anonymous,

On PBI the percentage values are treated has decimal, you need to use the number and not the percentage option when selecting the rules and then use the 0:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-by-rules-for-percentages

[Anonymous]

Thanks a lot!. That worked.