Can't get report screen to work

[mdsmith1]

I am brand new to Power BI.  I have been through the tutorials but my screens are not the same.

I have loaded some data which you can see in the graphic but it is graphing a "Count" of my data rather than the actual data. I have tried every button to change this to no avail.

Any help would be appreciated.

Mike

[hummingbird]

Hi,

If you want to visualize the actual data instead of a count of your data in Power BI, you'll need to make sure that you have chosen the correct field as the "Values" field in your visual.

To do this:

1. Select the visual you want to modify.

2. Go to the "Visualizations" pane.

3. In the "Values" section, choose the field you want to use as the actual data. If you have multiple columns, you may need to select the option to aggregate the data (e.g., sum, average, etc.).

4. You may also need to adjust the formatting options in the "Format" section of the "Visualizations" pane to get the look you want.

[mdsmith1]

I have changed over to the standard Power BI (not desktop) and find this produces reports that are much more useful.  I really believe that tabular reports are much more useful than graphical reports for 99% of business requirements.
Thankyou for all your help.  I will mark this as the Solution.

[hummingbird]

@mdsmith1 Does that answer your question? Mark it as a solution! 

[mdsmith1 · Accepted solution]

I am attaching screen shots showing the excel source file and what is plotting.

I don't want Sums, I want the details. I am unable to get a plot of the details.

Mike 

[hummingbird]

Hi,

In the Report view you can disable the sum or count by clicking the Down arrow next to "y-axis" in your case and selecting the appropriate calculation. In the Data view, you can remove the automatic sum by selecting the column and selecting Do no summarize in the Properties tab / Summarization of the Column Tools.

[mdsmith1]

If I click the down arrow under the y-Axis I get the screen below. There is no option for "actual values" its for options like "average" or "median"

The second screen shows what happens if I click on a column in Data View.  There is no property tab and no option for "remove sum".

The 3rd screen shows the Excel data table I am trying to depict. 

[hummingbird]

Hi,

So what exactly are you trying to do? 

You cannot visualise all data using the selected graph without selecting average, sum, minimum, etc or using a measure. 

You can remove the automatic Sum in the Data view as explained earlier.

[mdsmith1]

I have tried the following, 

- I selected my table.

- I clicked "Make a Report" with the option "Build from scratch."

- it took mw the the screen shown in the attached capture.

There is a place for "Add Values" in the lower right but it does not work.

What am I doing wrong?

Mike 

[hummingbird]

Hi, 

Do you have an option to develop the model in Power BI Desktop? I think that will give you all options with familiar screens. 

[mdsmith1]

I have downloaded the Desktop Version and loaded it with one product with sales over 12 months.

It insists on doing Sums. Yiou mentioned about clicking on "Properties" in the Data section.  I have opened up my Data Section and I cannot find the word "Properties". See attached screen shot.