Forum Discussion
Display result side by side from same column
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 |
Hi tejapowerbi123 ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Hi tejapowerbi123 ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 🙂
Thank you so much for your suggestion.
I have tried Martix and when you select multiple store rows will not show side by side.
tejapowerbi123 , I doubt you can get that kind of format
this one is most nearest, but I doubt will work for you
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.
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/
