Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 4
MFelix
Super User
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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Appreciate the reponse!

 

Simply, neither the box and whisker nor violin plot visualizations from the Power BI app store have formattable axis options. They're fixed to the data. I assume it's easier to format the data than re-invent the charts just have axis formatting available.

Hi - I've just come across this while repsonding to another post. What are you specifically after with the axis formatting for the violin plot custom visual? I'm the author and might be able to help/have a look for you. Alternatively, feel free to create an issue in the repo and we can discuss there.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.