Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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.
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.
@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
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/
@amitchandak I tried from below link but not did not get expected result.Thanks
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you so much for your suggestion.
I have tried Martix and when you select multiple store rows will not show side by side.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |