Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lian96022
Frequent Visitor

Gaps in Clustered Column Chart

I have a couple clustered charts using the same table. On one of charts the bars line up evenly however on the other chart it has these gaps between the bar. I have looked at the data and there is no missing data. Any suggestions as to what this may be causing this?

 

 

No gaps between barsNo gaps between barsGaps between barsGaps between bars

1 ACCEPTED SOLUTION

The problem you are running into is that if it "skips" it without leaving the space, then the user will not know there are no duplicate counts, for example.  You might reorder the list so that the ones that don't show up often are nearer the end, but the space tells the reader of the graph that there is a column missing there.  

View solution in original post

3 REPLIES 3
JoyCornerstone
Resolver II
Resolver II

The gaps in the 2nd graph are likely because there are no counts.  For example, in the graph on the right, red denotes "Duplicate Request".  In Dec 2018 and Jan 2019 there are no Duplicate Requests, so no red bars - thus a gap shows between the black (credit Approved) and the yellow (HR/WDS/Inquiry).

Is there a way if there are no counts to just skip it so it is not reflected in the graph? Would this reqquire a new column?

The problem you are running into is that if it "skips" it without leaving the space, then the user will not know there are no duplicate counts, for example.  You might reorder the list so that the ones that don't show up often are nearer the end, but the space tells the reader of the graph that there is a column missing there.  

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.