Design challenge : matrix, conditional formatting and target vs. actual

[zivhimmel]

Hi,

I'm working on converting a report from Tableau to Power BI.

The report, currently in Tableau, looks like this :

For every agent, there is a row, representing their performance this month. For every day, there is a column showing two values :

actual sales amount and the percentage of the sale amount comparing to their daily target.

So, for example, if an agent has a 100$ daily target and they make a 200$ sale, they are at 200% for that day.

There is also conditional formatting - if the amount is above the target, the cell is green, or if below - red. I don't believe Power BI currently supports such visual.

I see a few challanges here:

1. Diaplaying two values in one Matrix cell. I believe they can only be shown side by side and not one on top of the other.

2. Conditional formatting of a cell by comparing values of two fields

3. I don't even believe any kind of conditional formatting is available in a matrix.

Now, I haven't yet done allot with Power BI, just a few reports, so I may not be aware of some of the options.

Are you familiar with any ways to get close to the above picture ? Any custom visualizations maybe?

Also happy to hear about totally different ways to convey the same message.

Thanks !

[v-ljerr-msft]

Hi @zivhimmel,

---

I see a few challanges here:

1. Diaplaying two values in one Matrix cell. I believe they can only be shown side by side and not one on top of the other.

---

Yes, it is not possible to display two values in one Matrix cell currently. You can submit this requirement on Power BI Ideas. 

---

2. Conditional formatting of a cell by comparing values of two fields

3. I don't even believe any kind of conditional formatting is available in a matrix.

---

The idea for conditional formatting in matrix is already under planed. Please vote it up here to make this feature come sooner.

Regards

[BhaveshPatel]

The Sankey Bar Chart is more or less similar to what you would like to achieve.

PowerBI has broad range of visuals which can be browsed on this PAGE.

[zivhimmel]

Thanks @BhaveshPatel for the answer, but I can't see how this particular visual solves the problem.