Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

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.

 

 

 

amitchandak
Super User
Super User

@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

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

@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
Super User

@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! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.