Forum Discussion
Date format
Hi aryan,
You can create a calculated column like below:
dateupdate = FORMAT('HumanResources EmployeePayHistory'[RateChangeDate],"MMM") & "-" & YEAR('HumanResources EmployeePayHistory'[RateChangeDate])
Then create a new table:
Calendar =
DISTINCT (
SELECTCOLUMNS ( 'HumanResources EmployeePayHistory', "NewDateKey", STARTOFMONTH ( 'HumanResources EmployeePayHistory'[RateChangeDate] ),"YM",FORMAT('HumanResources EmployeePayHistory'[RateChangeDate],"MMM") & "-" & YEAR('HumanResources EmployeePayHistory'[RateChangeDate]) )
)
Then set the column YM sort by NewDateKey. Create a relationship between these two tables based on column dateupdate and YM, drag the YM column to chart X axis. See attached pbix file.
Best Regards,
Qiuyun Yu
ok but i have to take 3 different columns and my problem is when i remove hierarchy it is showing individual bars of 3 columns i want it as combained
Hi aryan,
What do you mean about "my problem is when i remove hierarchy it is showing individual bars of 3 columns i want it as combained"? From your original post, it looks like the issue is there are too many same month-year values in X-axis, in your picture, is February 2018, but you would like February 2018 disappears one time.
If you don't want to use the method provided in my previous post, please try below two methods:
1. When you put Date column without hierarchy in X axis, you can change X axis Type as Continuous instead of Categorical. If there are too many records, the x axis values will only display year values.
2. Drag Year and Month hierarchy to chart X axis, click Expand all down on one level in the hierarchy button, see:
Best Regards,
Qiuyun YuC D L Date 0 November, 2014 0 November, 2014 0 November, 2014 0 November, 2014 0 November, 2014 0 November, 2014 0 November, 2014 0 November, 2014 6.9 October, 2014 6.9 August, 2016 6.9 August, 2016 6.9 August, 2016 2158.9 November, 2015 2158.9 November, 2015 1910.2 November, 2015 2158.9 November, 2015 1294.1 October, 2014 126 March, 2014 9605332 March, 2014 -5178.95 October, 2014 7292.25 September, 2013 155936.1 September, 2013 46040.4 October, 2014 7851 March, 2014 9300 March, 2014 42103.8 March, 2014 172864.09 March, 2014 171100.51 March, 2014 136305713 October, 2014 149754093 October, 2014 136305713 October, 2014 149754093 October, 2014 679438.9 October, 2014 680781.5 October, 2014 679438.9 October, 2014 0 October, 2014 0 October, 2014 0 October, 2014 0 October, 2014 0 October, 2014 i need to display a bar graph according to date