cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
SamRounsevell
New Member

Formatting X Axis - display all values in order

I'm trying to show a count of sales alongside the quantity of outgoing communications on the same day:

 

If I choose Continuous it shows the dates in the correct sort order but hides most values:

Continuous.PNG

 

If I choose Categorical it shows all values but loses the correct date order:

Categorical.PNG

 

How can I display every day while keeping it in date order?

 

I have both a Date Hierarchy and the raw Date field (set as a date type in the query) changing between them doesn't seem to help.  

 

 

 

1 ACCEPTED SOLUTION

The other thing I noticed in your first post - in the second picture (when the X-Axis is Categorical)

 

Thy sorting the Chart - Sort by the Date - it looks like it was Sorted by Transactions

 

Click the ... in top right corner of the Chart and Sort By Date

 

Sort By Date.png

 

Yes if you have all dates you can create a column

Column = 0 and place it in the chart - that will force all dates to be seen

however you won't be able to use the legend if you do this...

 

HTH! Smiley Happy

View solution in original post

4 REPLIES 4
Sean
Community Champion
Community Champion

Is it also set as date in the Modeling tab?

Aha!


My Date field (not the Hierarchy) is Data Type: Date in the modelling tab.  

 

This is great but for some reason I can only

 

 

Modelling Date.PNG

 

That is in order but only displaying values with data (transaction count in this case).  
The Categorisation option under the X-Axis to show all values is not available now.  

 

The Date Hierarchy field has all the Modelling buttons greyed out when I select it.

I'm planning to upload a table of Dates and a Count of mail pieces, TV spots ,etc...could I cheat and just put a value in for every day with 0's for empty days?  Would that force the graph to display each day?

Edit: Thank you very much for helping 🙂  

The other thing I noticed in your first post - in the second picture (when the X-Axis is Categorical)

 

Thy sorting the Chart - Sort by the Date - it looks like it was Sorted by Transactions

 

Click the ... in top right corner of the Chart and Sort By Date

 

Sort By Date.png

 

Yes if you have all dates you can create a column

Column = 0 and place it in the chart - that will force all dates to be seen

however you won't be able to use the legend if you do this...

 

HTH! Smiley Happy

Ah, I never knew the sort function was there 🙂  Perfect, thank you very much!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors