Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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.
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |