Forum Discussion
Making the x axis range the same for multiple visuals - different data densities/frequency
Basically i have 3 line charts and one stacked bar chart. All three come from the same table and use the same variable for the x-axis. The stacked bar chart is displaying data with a different density (there are more points in the line chart data), and so there is a different start/end ranges for the x-axis due to dynamic ranging. I would like them to all be the same. I dont want to have to chage the start/end range for all 4 charts every time i load new data, or to zoom in on a particular range. Is there a way a slicer can be linked to the chart start / end ranges or something similar?
Example data set of what i am dealing with
Thanks!
Hey - I found a way to get around this issue and wanted to share it in case anyone else is looking for it.
The problem is that there are no values in cells for the lower frequency data. Basically there needs to be equal number of rows for each chart that you are making, and instead of those rows without data being blank, they need to have zero's as values. The Dynamic ranging will then include those data in the range displayed for all charts.
5 Replies
I'm thinking maybe a "Between" slicer?
Sounds like maybe you have to handle it in some DAX calculations. Can you provide source data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
