cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tejapowerbi123
Helper IV
Helper IV

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

 

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @tejapowerbi123 ,

 

Please refer to my .pbix file.

v-lionel-msft_1-1596162078348.png

 

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.

 

 

 

View solution in original post

8 REPLIES 8
v-lionel-msft
Community Support
Community Support

Hi @tejapowerbi123 ,

 

Please refer to my .pbix file.

v-lionel-msft_1-1596162078348.png

 

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.

 

 

 

View solution in original post

amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

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

Fowmy
Super User IV
Super User IV

@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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn   Join my Power BI User

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors