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.
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!
Solved! Go to Solution.
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.
I'm thinking maybe a "Between" slicer?
Unfortunately the between sliders dont work for what i need 😞
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |