The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Of course I have limited space on my dashboard but I'd like to see the axis of my barchart.
Can I adjust that somewhere? I'm okay with looking at smaller barcharts, as long as I can see the full y axis
Solved! Go to Solution.
It's a pain, the axes text alignment is controlled by an algorithm and you can't fix it with a single visual
I was able to get the result by using two visuals, a single column table visual with right aligned text (trick is to adjust the row padding to space the table rows out the same amount) and the horizontally narrow bar chart visual with no axes, titles etc. You might want to add the legend by snipping the legend as a picture and reinserting - that way the legend doesn't get cropped as well.
You get the right result by juggling the table row padding, and adjusting the vertical size of the adjacent bar chart until the table rows line up with the respective bar chart categories.
Table Formatting
'Sparse' table style, grid outline colour 'White', Row padding = 12, title off, Field formatting for 'Category' field - Alignment = 'Right'
Second visual is a bar chart with no legend, no X,Y axes.
Here's the example file - hope that helps!
It's a pain, the axes text alignment is controlled by an algorithm and you can't fix it with a single visual
I was able to get the result by using two visuals, a single column table visual with right aligned text (trick is to adjust the row padding to space the table rows out the same amount) and the horizontally narrow bar chart visual with no axes, titles etc. You might want to add the legend by snipping the legend as a picture and reinserting - that way the legend doesn't get cropped as well.
You get the right result by juggling the table row padding, and adjusting the vertical size of the adjacent bar chart until the table rows line up with the respective bar chart categories.
Table Formatting
'Sparse' table style, grid outline colour 'White', Row padding = 12, title off, Field formatting for 'Category' field - Alignment = 'Right'
Second visual is a bar chart with no legend, no X,Y axes.
Here's the example file - hope that helps!
Hi @Anonymous,
Lay out options for the Y-axis of visuals can be found in the format pane of the visual, see picture below:
If you enable the Y-axis it should show at all times. Hope this is what you searched for.
Regards,
L.Meijdam
User | Count |
---|---|
78 | |
73 | |
38 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |