Forum Discussion

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago
Solved

Power Bi Challenge - Round1

Hello Community Heroes! The challenge is to create a report of one simple native matrix visual along with a set of slicers. The purpose of the report is to visualize how different brands are pe...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Does 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.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    2 years ago

    lbendlin 
    I actually want to see The selected Brand1 first in the matrix, Brand2 2nd and Brand3 3rd. However, I love the idea of the chart. The matrix solution shall be preferred over other visuals, but as long as it is a native visual the solution shall also be acceptable.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    2 years ago

    lbendlin 

    Let 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. 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      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.

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        2 years ago

        lbendlin 

        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.