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
Minakshi
Resolver I
Resolver I

dynamic x-axis based on other slicer value selection

Hi Experts,
I have following structure of the data.
DataData
My customer wants to have dynamic x-axis based on Market.
1. When market is "Mid Size", they want to see  a visual (bar chart) Customer/sales
2. When market is "Big", they want to see bar chart Region/sales in the same visual.

Kindly help me with this. Can it be done ?

Date, Customer Name, Market and Region are the slicers on the page.
Thanks in advance

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @Minakshi 

If I understood your question correctly, I want to suggest building up the Model like the below picture.

- Separate slicer table for Big / Mid size is needed.

- All measures are in the sample pbix file link down below.

 

Picture1.pngPicture2.pngPicture3.png

 

 

https://www.dropbox.com/s/uxpzvgxnqpbra3f/minakshi.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

3 REPLIES 3
Jihwan_Kim
Super User
Super User

Hi, @Minakshi 

If I understood your question correctly, I want to suggest building up the Model like the below picture.

- Separate slicer table for Big / Mid size is needed.

- All measures are in the sample pbix file link down below.

 

Picture1.pngPicture2.pngPicture3.png

 

 

https://www.dropbox.com/s/uxpzvgxnqpbra3f/minakshi.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


@Jihwan_Kim Many thanks for a quick help. 

amitchandak
Super User
Super User

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.