Comparing two Metrics

[Anonymous]

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?

[V-lianl-msft]

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]

@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]

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.