Skip to main content
cancel
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

Reply
mdsmith1
Helper I
Helper I

Can't get report screen to work

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.

Mikepict1.jpg

1 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 

pict1.jpgpict2.jpg

View solution in original post

10 REPLIES 10
hummingbird
Helper II
Helper II

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.

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.

@mdsmith1 Does that answer your question? Mark it as a 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 

pict1.jpgpict2.jpg

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.

 

Screenshot 2023-02-18 112655.pngScreenshot 2023-02-18 112727.png

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. 

  

pict1.jpgpict2.jpgpict3.jpg

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.

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 

pict1.jpg

 

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. 

 

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.

pict1.jpg 

Helpful resources

Announcements
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.