Currently my x axis is the exact date, is there a way i can turn the ticker into showing Year only?
From this
To this
Also how do I shrink everything into the graph area - I don't to scroll it.
1 ACCEPTED SOLUTION
Hello @GAPER ,
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,
Then all the data point is going to be either on 2021,2022,2023
This is not my goal....I just don't want the ticker showing every day.
@GAPER 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
So power BI don't even know how not to show all of the ticks? This is stupid. Even Microsoft Excel can do that
Hello @GAPER ,
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,
Hi @GAPER
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
