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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pouyaNikzad
Regular Visitor

How can I have dynamic axis which is responsive on slicer value, without using bridge table, use DAX

Untitled.png

 

Hi everyone, I have a chart which I need that the x value (Axis) changes by changing the slicer value (this slicer is the yellow one that has all the Dims (x values)) and it comes from DimList table, for example at the moment the chart is totalfreight by custid, but i need if i check the 'empid' from the yellow slicer the chart value changed to totalfreight by empid. and this happens for all of the slicer values.

but I dont like bridge table or any methods that has bad effect on performance. because the FactTable has a billion rows and I modeled it in SSAS, tabular model and has live connection. Thanks in advance

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@pouyaNikzad,

 

That's reasonable. Then you should try bookmarks and buttons.

Here's a reference.

 

Br,

T

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi, thank you

but I dont want to use bridge table cause this has bad effect on my model performance, I looking for method that consider performance aspects on big size model too.

Anonymous
Not applicable

@pouyaNikzad,

 

That's reasonable. Then you should try bookmarks and buttons.

Here's a reference.

 

Br,

T

Seward12533
Solution Sage
Solution Sage

Currently you can't use measure or dynamically change what is on the X axis.  To do this I use Bookmarks and Selection panes in combination to switch between different charts to display.

 

Tip - for the bookmarks uncheck the "data" and have the bookmarks only hide/show the charts. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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