Forum Discussion
How to treat date format as numbers/integer while retaining date format?
Hi - I do a lot of monte carlo work with schedules where dates are the data we're counting accross the iterations. In Excel, I'm able to treat the date format as an interger, knowing the date value integer is behind it, in typical formulas like quartile and median to develop box plots.
I would really like to move into Power BI to streamline the workflow with the off-the-shelf box and violin plot vizs. However, no matter the date format, I can't treat it as an integer. Only when I convert to it's numerical underlying via simple data type "Date" to "Whole Number" or using the datevalue forumula. However, then my axis is numbers, not dates and illegible. Any thoughts? Thanks!
4 Replies
- MFelix
Super User
HI Anonymous,
Not sure of what you really want to achieve, some things can be achieved using measures or similar, but why don't you just simplify this and create a new column that is a copy of your Date column and convert it to numerical, then use this column as your values to have the quartiles and median and the original date column as your axis?
Regards,
MFelix
- MFelix
Hi Anonymous,
Not really sure if I understand what you are referring, I have made a simple test with some basic data and made a Date Column and a copy of that column with number. Used the Date column as my Category in the Box and Wiskers chart an I add the Date (month, year, quarter) in the axis and values used the values.
i don't use this type of chart and to what I can read this is a difficult chart to use based on the configurations.
Can you share some sample data and what you want to achieve and I can see if I can help you?
another option is to get in contact with the support of the creator of the box and whisker chart.
Regards,
MFelix
