Address storage visual

[danil_dorozhkin]

Hello.

So I have this request from my manager, perhaps someone would be able to help me.

I need to make a rectangular visual divided in sells, say 10 by 15, so there would be 150 equal sells.

I want each cell to represent a specific number (item), like from 1 to 150, but in the order I want. The number stays in cell, so I can recall it.

Each item has two characteristics, for example, Usage and Profitability.

Now the interesting part:

I want to conditionally format these items depending on values behind them. To make it simple, the Usage equals to index number of each cell, the smallest represent Red color, the largest - Green. So it would be gradiently colored rectangular.

Then changing the slicer value to Profitability, colors would change respectfully depending on Profitability value behind each item.

Thanks in advance for any help!!!

[danil_dorozhkin · Accepted solution]

Was able to solve it through custom visual Advance Card .

Does exactly what I need. Thanks to the auther!!

[v-chuncz-msft]

@danil_dorozhkin,

You may make use of the Matrix visual.

[danil_dorozhkin]

Thank you for your answer.

However, using matrix won't give the outcome I want.

I'm able to do this in Excel like in example below, and am wondering whether I can do it in PBI.

Any ideas?