I'm currently learning Power BI and attempting to do a little project, I prepared the data by myself, after loading into the Query Editor for transformation et al. Everything looks good, but when I switch to Table view to build my visualization, it only shows 0 values and skip some of the data, any explanation why this is happening and suggestions on how to fix will help. I attach a screenshot for better comprehension.
Data Looks good in Power Query Editor but only showing cells with 0 values in Table View
44 Views Asked by Samson Bitrus At
1
There are 1 best solutions below
Related Questions in POWERBI
- Does Power BI provide an OOTB Geographical Dimension Table
- How to change point color in Deneb while having lines be the same color as the legend
- SQL analytics endpoint and Semantic model not being created in MS Fabric Lakehouse
- Parse Dynamic Power BI table with selenium
- ALL() and REMOVEFILTER() Don't Work Correctly on My Report
- Market share growth versus last month, last year
- DAX query: trying to count unique entries that match two different criteria
- Azure Analysis Service, with an on prem gateway, in vnet
- Dax Many to Many Measure with Calender Date filters
- How to install NPGSQL and connect a PostgreSQL database to Power BI?
- Calculate average duration from text in power bi
- Power-BI / Dax: Count emails multiple times in a function based on the same dimension (#Order)
- Unable to filter in power bi dax query
- how can i obtain earliest day and lastest date per row/item number using Power Bi?
- Slicer Filtering on Drill-through Field Not Working
Related Questions in POWERQUERY
- Power Query / M Code, extract a list of tables into one main table, some column headers same but some different and in different order (and in row 2)
- Calculate average duration from text in power bi
- Repeat Value for Every Instance of Another Value in Excel without using Power Query
- PowerBI Azure Cost Management API timeperiod current day to x
- Table Restructuring Options in PowerBI
- Duplicate value in one column with different categories in another column in Power Query
- JSON parse JSON with changing Key and changing type of value (list or string)
- Dynamic Filtering of Calculated Table Not Working with SELECTEDVALUE(slicer) in Power BI
- Connect GraphQL to PowerBI
- Power Query - Skip query based on condition
- How to move multiple power query tables into one worksheet together in Excel?
- can I create a calculation that shows in a pivot table the percent of filter rows?
- Refresh Active Sheet
- Can a Power Query get the M code of another query?
- Copying a Excel spreadsheet into a new workbook where it mirrors the original spreadsheet with formulas and formatting
Related Questions in DATA-ANALYSIS
- Pneumonia detection, using transfer learning
- duplicates within a 30 day period in samples from location A
- Understanding numeric_only boolean parameter in Pandas
- How can I turn categories into columns with percentage results?
- Unable to filter in power bi dax query
- YTD sum by month, using only latest value for each month
- Stopping a Power BI Table visual slicing the result of a virtual table
- Removing duplicate data conditionally in Excel
- How can I compare the similarity between multiple sets?
- Forecast the revenue for next month using 1 year historical data
- issue using dataset with data analysis project
- How can passive terms be rendered in the calculation of an MFA in R?
- Upsert using DuckDB
- Dynamic Filtering of Calculated Table Not Working with SELECTEDVALUE(slicer) in Power BI
- Mediation Analysis in R with two mediators in a repeated measure experiment (within-subject design)
Related Questions in POWERBI-DESKTOP
- Power-BI / Dax: Count emails multiple times in a function based on the same dimension (#Order)
- Unable to filter in power bi dax query
- DATEDIFF "An invalid numeric representation of a date value was encountered" Error
- YTD sum by month, using only latest value for each month
- Get embedded url of pbix power bi report that has paginated rdl report inside it
- Stopping a Power BI Table visual slicing the result of a virtual table
- Need simplification on this DAX code in Power BI
- VEGA LITE : stacked bar spacing between categories with fixed order
- Can I package a third party application installer along with my electron application?
- Record real time values of a visual matrix in Power BI
- Table Restructuring Options in PowerBI
- How do I count certain records in one table based while excluding records based on date values in another table?
- Keeping conditional formatting consistent when filtering
- Matrix calculated based on the previous value
- Pbi horizontal visual table
Related Questions in BUSINESS-INTELLIGENCE
- Does Power BI provide an OOTB Geographical Dimension Table
- Customer Churn Calculation
- Data Looks good in Power Query Editor but only showing cells with 0 values in Table View
- Rebuilding fact tables with over 30 million rows takes over 1hr
- If there a way to determine if a set of values contains a single instance of a string and create a new variable with only that string?
- Indexed parent-child hierarchy table to fact table
- the right grain of a fact table in data warehouse
- Donut Chart and percentage visualisation in Tableau
- Data vault 2.0 hub end date
- Cumulative Total of DAX Measure without Date Filters
- Create a graph for the previous weeks using postgres
- Many-to-many relationship database design
- PowerBI remember filters when opening new report from another report
- BigQuery : Time Stamp of Next Events are Lesser Than Previous Event's Time Stamp
- Download file in AWS S3 bucket using SSIS
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?

Found my mistake, I didn't scroll all the way down, I expected the data to be sorted by
Datecolumn by default, but it sorted by theThreescolumn, that's why I got all the 0's first.