Altering X axis Ticks

[GAPER]

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. 

[Ritaf1983 · Accepted solution]

Hi @GAPER 

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

[Ritaf1983 · Accepted solution]

@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

[Ritaf1983 · Accepted solution]

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

[Ritaf1983 · Accepted solution]

Hi @GAPER 

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

[GAPER]

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. 

[Ritaf1983 · Accepted solution]

@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

[GAPER]

So power BI don't even know how not to show all of the ticks? This is stupid. Even Microsoft Excel can do that

[Thejeswar · 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,

[Ritaf1983 · Accepted solution]

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