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

[pouyaNikzad]

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

[Anonymous]

@pouyaNikzad,

There is a way to make dynamic x-axis based on slicer.

Check these out:

http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi

http://breaking-bi.blogspot.com/2016/06/power-bipowerpivot-using-slicers-to.html

[pouyaNikzad]

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 · Accepted solution]

@pouyaNikzad,

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

Here's a reference.

Br,

T

[Seward12533]

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.