Forum Discussion

jderekc's avatar
jderekc
Icon for Helper IV rankHelper IV
8 years ago

Clustered bar chart X-axis with time

Hi all,   I have a clustered bar chart where the X-axis is a time series and the Y-axis is a quantity value for product count comparisons between two systems.  I doubt that is important to any of y...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi jderekc,

 

After you use FORMAT function in DAX to get a date column, you can create a calendar table(=CALENDAR("2017-1-1",TODAY())), change date column in calendar table as date data type. Then create a relationship between those two tables based on date column. Then you can drag the date column from calendar table to the X-axis of the chart. The X-axis value should be continuous now. 

 

Best Regards,
Qiuyun Yu 

MGPAnderson's avatar
MGPAnderson
Regular Visitor
8 years ago

I have the same issue and what you are proposing is an awful lot of effect for one report, when it is a basic bug in Desktop.  I have several of these in my first reporting solution using Power BI and frankly, I am getting tired of having to code workarounds, when the visuals and the integration between Desktop and Dashboard should be better.  Please can Microsoft work on all of the bugs rather than giving us workarounds?  (I acknowledge that this ticket is 3 days old but really, this must be a long standing bug.)  It's such a shame as so much effort has gone into the data engines that the visuals but this and the other smaller issues that I have found, in just one week of using Power BI, just let it all down.  This issue is indicative of all bar charts.