Display result side by side from same column

[tejapowerbi123]

Hello Community,

Please review below requirements and provide your suggestion.

When user select store slicer (any number of store) from slicer then can see comparison between store and sales.

Can any one has any suggestion?

I have a slicer with store data,

Store Slicer

1

2

3

4

Here is the raw data,

Store Data
Store	Sales
1	5
2	10
3	15
4	20

Here is the result,

Final Result
Store	Sales	Sales	Store
1	5	20	4

[v-lionel-msft · Accepted solution]

Hi @tejapowerbi123 ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

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

[amitchandak]

@tejapowerbi123 , I doubt you can get that kind of format

this one is most nearest, but I doubt will work for you

https://www.youtube.com/watch?v=WSnB5y2JXv8

[tejapowerbi123]

@amitchandak 

Thank you so much for your suggestion.I have tried that one and it is not for me.

Stores is in same column and sales is in same column that's is the issue.

I am trying to use concept from website,Where you can compare product side by side but i am not able to figure it out.

[amitchandak]

@tejapowerbi123 , Try matrix with show on row with store on column/row.  That will move measure on the row . You can see what looks better. 

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[tejapowerbi123]

@amitchandak  Thank you so much.I will try it and will post my response.

[tejapowerbi123]

@amitchandak  I tried from below link but not did not get expected result.Thanks

[Fowmy]

@tejapowerbi123 

No clear about the final result you are expecting?

Try with Matrix Visual?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[tejapowerbi123]

@Fowmy 

Thank you so much for your suggestion.

I have tried Martix and when you select multiple store rows will not show side by side.