Forum Discussion
Community ChampionPower Bi Challenge - Round1
My submission is attached.
(Edited to hack the sort order to match specifications.)
Super UserDoes it have to be a matrix? Seems like a chart would be a more appropriate solution unless you want to consciously single out Brand1 (it is compared against, but not the basis, according to your rules). A chart would remove that "unjustice" or skew.
Community ChampionLet me elaborate on my response to your question.
This challenge was inspired from a real life requirement. Originally, the requirement was to have one brand ("scenario" in the real life requirement) selected as a reference and then another scenraio selected to compare it with the reference scenraio. Then new requirements came up, that is to compare three scenarios at once where the reference scenario is always tye one to the left. In all cases when comparing two scenarios, one of them has to be considered as a reference, this is why the appearance order in the matrix is important.
However, the solution to this challenge does not have to comply with this. Better ideas are always appreciated.