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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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. 


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.



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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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