Forum Discussion
Altering X axis Ticks
- 2 years ago
Hi Anonymous
If you aren't using the dates table, just add the year column to your fact table and put this column on the graph.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 2 years ago
Anonymous Then unfortunately this is not available in the way that you described.
As an alternative to save the place you can instead of date some workaround like 2 digits of year and the number of days in the year, it will take much less place :
something like : 20_1, 20_2....20_365 etc...
21_1 ,....22_1...
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly - 2 years ago
Hi Anonymous
Power BI is not a competitor to Excel, and it is true that there are gaps in functionality for some visualizations. Currently, you can try visualizations like DENEB which are more flexible, but require the use of code.
More information :
https://www.youtube.com/watch?v=_fuPqyuaBnQ
Additionally, any missing feature/option can be proposed as an improvement suggestion here:
https://ideas.fabric.microsoft.com/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 2 years ago
Hello Anonymous ,
There is no direct way to get this working as per your ask. But you can do a workaround to get a similar view. But it has few downsides like when you open it in focus mode the axis might not be visible.
Below is the screenshot
What I did is
1. I am having two visuals placed one above the other
2. Top visual shows the data points and Y-axis
3. The Bottom visual shows only the x-axis only the Year value
4. The X-axis in the top chart is given a font color of white. Hide the x-axis title
5. The Y-axis in the bottom visual is made to font white. The Line color is also made to white
6. The Two visuals are grouped together to make it feel like one visual
If this helps, mark it as a solution! Appreciate your kudos!
Regards,
So power BI don't even know how not to show all of the ticks? This is stupid. Even Microsoft Excel can do that
Hi Anonymous
Power BI is not a competitor to Excel, and it is true that there are gaps in functionality for some visualizations. Currently, you can try visualizations like DENEB which are more flexible, but require the use of code.
More information :
https://www.youtube.com/watch?v=_fuPqyuaBnQ
Additionally, any missing feature/option can be proposed as an improvement suggestion here:
https://ideas.fabric.microsoft.com/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly