cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koshur Regular Visitor
Regular Visitor

BI does not detect all values in excel column

I have A bid status column which has 12 different types of values. But when I plot any grpah/chart only 7 random show up. There are no fiters applied whatsoever.

Screen Shot 2016-06-12 at 12.03.32 AM.png

Screen Shot 2016-06-12 at 12.03.32 AM.png Screen Shot 2016-06-12 at 12.04.44 AM.png

1 ACCEPTED SOLUTION

Accepted Solutions
Baskar Super Contributor
Super Contributor

Re: BI does not detect all values in excel column

Hi Koshur,

 

I suggest you try the same value in tabular report and check it,

 

if you receive all 12 value then its very small so it cant visible in donut chart

or

check the data set.

 

 

3 REPLIES 3
wonga Established Member
Established Member

Re: BI does not detect all values in excel column

@koshur

 

Check to make sure you have all 12 values in the actual dataset in Query Editor. It's possible the other values has too small of "value" so they don't show up on the graph itself. 

 

 

Baskar Super Contributor
Super Contributor

Re: BI does not detect all values in excel column

Hi Koshur,

 

I suggest you try the same value in tabular report and check it,

 

if you receive all 12 value then its very small so it cant visible in donut chart

or

check the data set.

 

 

koshur Regular Visitor
Regular Visitor

Re: BI does not detect all values in excel column

i checked the filters again, it looks like there was one left at report level. I see more values now. Will have to recheck them again. Ideally all of them should show as they all have values.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 264 members 2,775 guests
Please welcome our newest community members: