cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlB
Super User
Super User

Show all items in X axis

Hi all,

I have a line and clustered column chart with week number in the x axis. I've added new data in the last refresh and, although all the data is shown correctly, the x-axis is now showing only the even numbers. How can I force all of the week numbers to be shown? In the screen capture below, the top one is what is happening and the bottom one what I would want (consider only the x-axis, ignore the different data in both charts).

 

Many thanks

 

 

The bottom one is what i'm afterThe bottom one is what i'm after 

12 REPLIES 12
Nikola237
Helper I
Helper I

Why is everything in Power Bi so counterintuitive or hard to get done? The most simple features need a work around in order to make them possible.

v-danhe-msft
Microsoft
Microsoft

Hi @AlB ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-danhe-msft 

Not yet. I will have a loom at @Nolock's suggestion with Json file

Thanks @Nolock  and @Greg_Deckler  for the tips

Greg_Deckler
Super User
Super User

Are you using Continuous or Categorical for you X-Axis?


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Thanks @Greg_Deckler , I didn't know about that 🙂

 

Capture.PNG

@Nolock  @Greg_Deckler 

 

Thanks guys. Going for categorical solves the issue but I have quite a lot of charts like that in the file. It'd be quite time-consuming to go chart by chart changing from continuous to categorical. Any idea on how to do that in a faster, more convenient way?

Many thanks

 

Give @Nolock the damm trophy.

Hi @AlB ,

I am afraid it may could not support all visuals, you could vote below links for your visuals or could submit an idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=categorical%20x-axis

If your problem could be solved, don't forget to close this topic.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Nolock
Memorable Member
Memorable Member

Hi @AlB and @Greg_Deckler,

 

WARNING: the following doesn't work, but it should be mentioned.

 

All Microsofts modern file formats are zipped files and folders. I've tried to unzip the pbix file and opened the file Report/Layout which is a JSON file. I changed a property (categorial/continuous) of a chart, zipped everything again and voila an error message that the file is corrupted. Then I tried the same once again only with changing a title of a chart. Also didn't work. It means there is probably a fingerprint somewhere in the binaries.

If it worked you could script it with ease. Unfortunately it doesn't 😞

Nolock
Memorable Member
Memorable Member

Hi @AlB  and @Greg_Deckler,

my next try, maybe you will find a bug in my solution and will be more successful than I was.

My next idea is to use Report Themes - create a new JSON file with a report theme and apply it to every report. According https://docs.microsoft.com/en-us/power-bi/desktop-report-themes it is possible to set all column charts to categorical or continuous (check the JSON file at the end of the MS doc page). I've tried to set many different properties, they worked but setting axisType for categoryAxis didn't. 

Do you have any idea why the following JSON theme doesn't work?

 

{
    "name": "My Theme",
    "visualStyles": {
        "columnChart": {
            "*": {
                "categoryAxis": [
                    {
                        "axisType": "Categorical",
                        "fontSize": 14
                    }
                ]
            }
        }
    }
}

@Nolock - Have you looked at powerbi.tips to generate your theme code? @Mike_Carlo might have some insight into this.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Nolock
Memorable Member
Memorable Member

Hi @AlB,

 

I think it is the standard behavior of all charts I've seen in many products. If there are to many values on an axis, only some of them will be displayed to stay well-arranged.

How to enforce it? Increase the width of your chart, which works for now. But it won't work, wenn you get a new data.

 

Capture.PNG

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!