Compare 2 product info in single visual

[Mahadevaraobc]

Hi Experts,

require your help on achiveing the following,

Compare 2 products in different slicers

ex: Product A in 1st slicer and Product B in 2nd Slicer and its values should be shown in line chart.

Both Products will be in same column.

[v-jingzhang · Accepted solution]

Hi @Mahadevaraobc 

If you want to compare two products' values in a line chart, you can put product column in Legend box. As a result, each product will be shown as a line. You just need one slicer to pick which products to shown on it. 

If you want to use two slicers, you could add two product tables which only contain product column. Then create two measures to calculate the value based on selected products in slicers. Use these two measures as Values field and no Legend field is needed. 

Sales Product 1 = CALCULATE(SUM('Table'[Sales]),'Table'[Product]=SELECTEDVALUE(ProductTable[Product]))

Sales Product 2 = CALCULATE(SUM('Table'[Sales]),'Table'[Product]=SELECTEDVALUE('ProductTable 2'[Product]))

See page 1 and page 2 in the attached pbix. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[MFelix]

Hi @Mahadevaraobc ,

First of all if you are using the same column to make two separate slicers you can have issues on the filtering of the visualizations because one slicer will overstep the other one so you will not get results from one of the slicers, in this case best option is to have it on a single slicer or making use of a disconnected table.

Regarding the question about the difference in values you can do it by using the following measure:

Difference = CALCULATE(SUM('Table'[Value]), 'Table'[Item] = Max('Table'[Item]))- CALCULATE(SUM('Table'[Value]), 'Table'[Item] = MIN('Table'[Item]))