Visual Doesn't Appear To Be Showing Correct Data

[djs25uk]

Dear All

In my table, I have created a column that calculates how many missing donations each person. You can see some of the values here, but not all the rows are visible - basically, the values range from 0-4 for this group of donors.  

I want to create a visual that shows 'Number of Missing Donations' along the x-axis, for example, 1, 2, 3, 4 and then the count of how many people are missing this many donations on the y-axis:

It is showing some of the data correctly. The green values are being shown correctly but the reds are not being shown at all. 

Number of Missing Donations	Number of People
1	6
2	1
3	1
4	1

I cannot understand why and I've spent hours looking at the chart/data/properties etc. 

Here is what I am using for the visual:

Many thanks

Dan

[v-robertq-msft · Accepted solution]

Hi, @djs25uk 

According to your description, I created some test data, then I can get the expected column chart, you can take a look:

This is my test data:

I create a column chart and place fields like this, then I applied the filter like this:

And I can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@djs25uk , if cc_missing_donationcount is a column and have value 1,2,3,4 , then it is possible. else not possible with this information

[djs25uk]

Yes, CC_MissingDonationsCount contains 180 rows and the values all range from 0, 1, 2, 3 and 4. Along the x axis should be all the distinct values 1, 2 ,3 , 4 and then on the y-axis should show how many there are for each. This works, but it isn't showing any count for 1 missing donation, yet there should be six. 

When I filter the table of data to inspect it, I can see there are six 1's, but this does not show in the visual at all...

[amitchandak]

@djs25uk ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[djs25uk]

Hi - the first image is the sample data and the second image is the sample output. As a table, the sample output looks like:

Thanks

Dan