Forum Discussion
Power Bi Challenge - Round1
My submission is attached.
(Edited to hack the sort order to match specifications.)
I 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.
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.