Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Comparing two Metrics

Suppose I want to compare two brands across metrics in a table. I want to give the user the option to dynamically select the 2 brands from a list available. Is it possible in Power BI?

Tips and Tricks

3 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi Anonymous , 

     

    You could try to create measures for all the options you want to compare, and then show them with card visualization.

    You can refer to this .pbix

     

    Best Regards,

    Liang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      V-lianl-msft,

       

      Thanks for answering the post.

       

      My question was however, a little different.

       

      Considering your dataset:

      Is there  a way that I allow the user to compare A vs B or A Vs C or A Vs B Vs C (Basis user selection) for suppose Avg_Price or Avg_Discount?

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        You can try to create measure for all the options you want to compare, and add the measure to table visual then use slicer to interact with table visual.  If you mean to dynamically add comparative columns in the created visualization, this is not feasible.

         

        Best Regards,

        Liang 

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.