Forum Discussion
Advocate IIconvert numeric value to year (DATE field)
I am trying to use one of the custom visuals from the Power BI Market place called 3AG Systems - Column Chart with Variance
It requires that the your category field be a date variable. I have a date variable that Power BI only view as a numeric value. I assume that is because is only the year (i.e., 2018). How do I covert this numberic value to a date value. The edit query field conversion does not change the value. See example below:
Before
After
As you can see the date move to 1905. Please advise.
Well that's what 2016 as a numeric date value ought to convert to... assuming it doesn't really matter what date in a given year you need it to be, make a custom column saying "01/01/" and then merge that with your year column. It should then give you a format that you can convert to date type.
HI, Bbrown44
After my test, the category field doesn't need a date variable.
for example:
I have three type of category: text, number, date
then I separate drag them into the category field of bar chart with variance.
They work well
Also If you want to convert numeric value to date.
you do it like this:
change the column type into Text first.
for example
then convert to date
Note:
When converting text to date and this window appears
Click Add new step
Otherwise it will not success.
Best Regards,
Lin
