Forum Discussion
Helper IHow to duplicate this Excel table in PBI?
For the colours, it should be easy enough to change the colours used in the conditional fomatting so that it uses red-green instead of orange. And maybe consider adding a middle colour if you need more control over the colours.
And for your second issue, you can drag more than one dimension into the columns of a matrix visual - so as long as you have the type in the raw data, just put that under the Unit dimension and click on expand all levels down a level on the actual visual
Super UserFor the colours, it should be easy enough to change the colours used in the conditional fomatting so that it uses red-green instead of orange. And maybe consider adding a middle colour if you need more control over the colours.
And for your second issue, you can drag more than one dimension into the columns of a matrix visual - so as long as you have the type in the raw data, just put that under the Unit dimension and click on expand all levels down a level on the actual visual
Donny620Thanks for your help! Actually I marked this as solved but did not realize there was one more criteria that the PBI Matrix wasn't doing. In the Excel table the conditional formatting gradiant is done per column. But if I try to format the matrix as specified above, it does a gradiant for every cell. Is there a way do have each sub column (the Type column and the total columns) be indepent in it's formatting?
E.g. this is what I see in PBI
This is what I want in PBI: