Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Group Months in Bar Chart

‎10-04-2016 06:25 AM

I am looking to group months in a bar chart. I have 2014-2016 data and would like to see the Months together for YOY comparisons. Can't figure it out with any configurations I try as far as the Shared axis or Column series.

Message 1 of 6
1,845 Views
0
5 REPLIES 5
Bokazoit
Responsive Resident
Responsive Resident

‎10-04-2016 06:34 AM

Have You tried creating a column called Year and entered that into the legend part?

Message 2 of 6
1,841 Views
0
Anonymous
Not applicable
In response to Bokazoit

‎10-04-2016 06:56 AM

Capture.PNGCapture1.PNG

 

Yes.. Here are the results i get. Can't lump the months together it seems

Message 3 of 6
1,833 Views
0
Bokazoit
Responsive Resident
Responsive Resident
In response to Anonymous

‎10-04-2016 11:24 PM

The issue is the shared axis that has month as primary, they need to share the same year column

Message 4 of 6
1,818 Views
0
Anonymous
Not applicable
In response to Bokazoit

‎10-05-2016 06:10 AM

@Bokazoit

 

I am not sure what that means.. Can you walk me through how I fix this?

Message 5 of 6
1,809 Views
0
Anonymous
Not applicable
In response to Anonymous

‎10-05-2016 10:14 AM

@Bokazoit

 

Not sure if this has anything to do with it, but I am not given a date hierarchy when dragging the Month in. My data is an import, not a direct query, so it should have hierarchy, correct?

Message 6 of 6
1,804 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All