Forum Discussion

djs25uk's avatar
djs25uk
Helper I
5 years ago
Solved

Visual Doesn't Appear To Be Showing Correct Data

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...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
djs25uk
Helper I
5 years ago

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