cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

values in a column visible in query but not all visible in table/matrix visual,

All values show in a column display in power query. Same values show (correctly) in the table view. 
Pulling the column into a visual shows blanks for most, and the table view show null.

Any assistance greatly appreciated

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: values in a column visible in query but not all visible in table/matrix visual,

The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: values in a column visible in query but not all visible in table/matrix visual,

Yes,

Request data via sql statement from oracle database.

Query displays an estimated account value and fees for. example below:

Acct NameEstimated valFee amt
Mets0null
Yourk155000

3000

Guts0null
Mike8180002125

 

When the above is pulled into a table or Matrix visual the results are below.

Acct NameEstimated valFee amt
Mets0 
Yourk155000 
Guts0 
Mike8180002125

 

No Measures or added columns for the above data. Please note, the Fee amt was determined by calculation before exporting to power bi.

The table is connected to a date table dy date received (not shown in this example).

 

Thanks for taking a look.

 

~Kd

Highlighted
Community Support
Community Support

Re: values in a column visible in query but not all visible in table/matrix visual,

Hi @kightd ,

 

Please check if this is caused by the Date table. For example, filter the data with date slicer.

 

It will be best to provide some screenshots. Please cover sensitive information.

 

 

Best Regards,

Icey

 

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

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors