Forum Discussion
Clustered Bar Chart with Dates on Horizontal Axis
This is typically very simple to do in Power BI. Can you share the model, or some screen shots of the data types or issue that you are seeing?
I just loaded in some data as in the table below. Date is in date data type, and Ref is in text data type. I add Date to the Axis of a bar chart, Ref to the Legend, and Count of Ref to the Value. Is this visual what you were looking for?
Thank you for your response. Unfortunately that's not quite what I'm after.
The end goal is to replcate a chart I created in Excel. This is a clustered bar chart where all the series are 100% overlapped, and one of the series is formated completely white (fill and outline) to give the appearance of bars which cover a date period:
The first step I was attempting was to create a bar chart with just one or two series. Here's a screenshot of the dummy data I was working with (the data type is 'Date/Time' for both START and FINISH fields and yet I can only get the data to be displayed as 'Count' or 'Count (Distinct)' when I try to create a chart):
Hi pjb,
Based on your description, I'd like to suggest you use the gantt visual, it will more suitable for your requirement.
Regards,
Xiaoxin Sheng