Forum Discussion
Helper IIIStacked Column chart - creat own y axis
I am using a field on the y axis which is numerical 1-10, the data type is set as whole number in the edit queries and modelling sections. In the format section for the visual i cannot see the option under the y axis for type (continuous or categorical), the type placeholder is not showing.
So I want to create my own Y axis with only 3 values: 0, 5, 10
How can I do this using a measure
3 Replies
- amitchandak
Super User
ryanb11 , I do not think there much control on the y-axis other than start / end. There no option tick interval yet. So on standard visual, I doubt you can.
you can check custom visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
- MFelix
Hi ryanb11 ,
the Y-axis doesn't have continuous or categorical values you also cannot define the major and minor values of the Y-axis.
The only way to influence the y-axis is to reduce or increase the size of the chart or adding the title and other legends and playing around witht the sizes of the letter of those elements, example at the below:
V-lianl-msftCommunity Support
Hi ryanb11 ,
For current Power BI, it is impossible to custom the interval on any axis. You may vote on these ideas:
https://ideas.powerbi.com/ideas/idea/?ideaid=8d290c47-1aba-4044-920c-ba0ae3981742
https://ideas.powerbi.com/ideas/idea/?ideaid=6ba30ae6-6243-456a-9743-64441ddd7644
An alternate method can be to do graphs with R or python.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
