Forum Discussion
Community ChampionPower Bi Challenge - Round1
My submission is attached.
(Edited to hack the sort order to match specifications.)
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.
Super UserI would use a single brand slicer with multi choice. Then I would allow the users to choose whatever brands they want to compare. And as I mentioned earlier I would represent the data in a column chart and then let the user make the over/under decisions with their eyeballs.
"Comparing against a base value" makes sense but it would not need to include pitching brand 2 against brand 3.
- tamerj1
What would be the definition of the formula without a reference value? Using one slicer would make it ambiguous. Not knowing which one is the reference value makes the comparison less meaningful. This is why the requirement above clearly says "3 different slicers". You can however keep only one base scenario with two comparisons, that would also make complete sense.