Power BI Report Data Display - Snack 5

Slightly funny story.  Someone contacted me last week and said they can't see anything in their report.  

We only imported the data last time.  

Now, we will visualize it and this won't take any time at all.

Head back over to the Power BI service online and let us see what we can see.

1. Click "Workspaces"
2. Click "My workspace"
1. At least two things are listed and for me, those are:
1. Financial%20Sample
1. Type = Semantic Model
1. This is the data!
2. FinancialSample
1. Type = Report
1. This is the report you created based on that data.
3. Open the one where Type = Report
1. A blank screen appears!!
4. Click "Edit"
5. In the right sidebar is the imported dataset
1. For me, it is simply named "financials"
1. Yours might be "Report-Result1" or "Worksheet" or "Sheet1" or whatever the Excel worksheet was named.
2. Click the little " > " next to the dataset name
1. A list of all the columns that were in the spreadsheet appear.
6. Under "Visualizations" in the right sidebar,
1. Click the little button that looks like a table.
1. That is the one that has a white grid, not the one that is partially blue.
1. See the attached screenshot that has a little red box around this feature.
2. On the left of the screen, a box appears that says "Select or drag fields ..."
7. Under "Data" in the right sidebar, quite literally do what that box says to do.
1. Use the check boxes that appear there or click on those column names and drag them over into the box on the left of the screen.
1. Make absolutely certain one of the columns is a date.
1. Add them all if you like, or just the ones you have a greater appreciation for.
2. If another box appeared when you went through this, that is ok.
1. For the empty one you would like to get rid of ...
1. Hover over the box and a little menu will appear above it.
1. Click the " . . . "
2. Choose "Remove"
8. File > Save

Your screen should look somewhat similar to the screenshot.  That with your data box has handles you can grab and stretch it out to see more of your data.

You might have noticed that the date looks kind of funny too.

This is what is called a hierarchal view.  

Power BI always displays dates in that format by default. 

We will get that fixed next time.

Questions? As always, post them up below.