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.
I'm not really sure how to title this question, but hopefully my description will be clear:
I have related data that has some data on the scale in 10s to 100s and some in tens of thousands. When I plot this on, say, a line chart, I get a load of points right at the bottom of the chart and a load at the very top of the chart and lots of empty white space in between, meaning you really can't see what's going on at either end of the scale. What I want is to be able to truncate the scale of the chart axis so it chops out all the unnecessary white space between say 300 and 15000 which would give me the bottom half of the chart showing the low-end details and the top half the high-end details. I've seen this in the past (not from PBI) with the numbers removed from the axis represented by a zig-zag line.
Is that doable in PBI?
@Anonymous,
In the Format section of the Visualizations pane, expand the Y-Axis card, try setting Scale type, Start and End.
Thank you for this suggestion. Setting a static scale against a dynamic plot isn't a viable solution.
For example. If I set the scale from 1-10 for one selection but the next selection is from 100-1000, then the static scale from 1-10 is useless. Is there a better solution?
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |