cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ichebobo Helper IV
Helper IV

X-axis label to show after every 4 hours or 5 hours

Hi,

Please assist.

My data displays after every 30mins on the X-axis. but I want the X-axis label to show after every 4 hours or 5 hours

(X-axis display label only) 

I have tried using bin in grouping  but it distorts the 30mins display data as all i want is just the label so my x-axis dont look clustered and can be easily read.

Also I want the label orientation to be horizontal instead of vertical.

See attached. What I want is as shown on the left and not as is on the right.

Please help

Show_Label_Xaxis.PNG

5 REPLIES 5
Super User IV
Super User IV

Re: X-axis label to show after every 4 hours or 5 hours

Perhaps try categorical and adjusting your minimum category width? You also might have to look at a custom or R visual.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

ichebobo Helper IV
Helper IV

Re: X-axis label to show after every 4 hours or 5 hours

Thank you for your suggestion:

My X-axis is already on categorical.

Please How can I adjust minimum category width?..Where is the option for such..

Also which custom or R visual to achieve this??

Microsoft v-ljerr-msft
Microsoft

Re: X-axis label to show after every 4 hours or 5 hours

Hi @ichebobo,



 

I have tried using bin in grouping  but it distorts the 30mins display data as all i want is just the label so my x-axis dont look clustered and can be easily read.

Also I want the label orientation to be horizontal instead of vertical.


What if you simply use Continuous type for X-Axis?

 

Based on my test, by using Continuous type for X-Axis will adjust the label automatically, so the X-Axis don't look clustered and can be easily read. Smiley Happy

 

Before using Continuous type for X-Axis.

 

r1.PNG

 

After using Continuous type for X-Axis.

 

r2.PNG

 

Regards

ichebobo Helper IV
Helper IV

Re: X-axis label to show after every 4 hours or 5 hours

Hi,

I've used the continous but get attached meshed lines. This happens when i select a particular day in the above bar chart. The bar chart is in categorical. Did you select a particular day from the bar chart??..What else did you do. I have tried this severally before but keep getting the meshed line graph unlike what you are showed here. Please helpcontin.PNG

Microsoft v-ljerr-msft
Microsoft

Re: X-axis label to show after every 4 hours or 5 hours

Hi @ichebobo,

 

Could you share a sample pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here, or sent it to me in private message. Do mask sensitive data before uploading. Smiley Happy

 

Regards

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors