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.
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 fields3. 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.
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.
Thanks @BhaveshPatel for the answer, but I can't see how this particular visual solves the problem.
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!