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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
milindsaraswala
New Member

Data with date/time format

I am very to the Power BI and I am learning it by myself. I have just sign up free power BI account. For learning purpose I took data of "Case Data from San Francisco" I exported those data in xlxs format and imported into the Power BI.

As per the suggestion of Power BI, I just defined the Excel data to table by pressing ctrl + T.

Now the problem  like

  1. I cannot make any chart by status (i.e. open or close)
  2. I cannot make any chart by date on the basis of close date or open date

Many more things. Now my question is do I am missing something? Do I have do something with excel file before importing it?

Sorry I am asking lot of questions. I am just new learner. 

 

1 REPLY 1
Greg_Deckler
Super User
Super User

I just recreated your steps. Took me a minute to figure out how to work with the data, but was able to create a column chart with Status. See below, if you substitute Opened or Opened Data for Supervisor District, you will get similar visuals. However, all of this being said, there are limitations within the Service for manipulating data and such. You will probably have better success if you download Desktop (free) and import your data into that and then publish.

 

cases.png



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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