Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi
considering the title of the topic and the image below,
How i can solve this considering i dont want to delete rows with errors.
Solved! Go to Solution.
The fastest way is to select that column, click the dropdown next to Replace Values, and select Replace Errors. Replace them with 0 or null. The word "null" will show up as a value in italics, and is equivalent to a blank in DAX. A zero might be better, but your call.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe fastest way is to select that column, click the dropdown next to Replace Values, and select Replace Errors. Replace them with 0 or null. The word "null" will show up as a value in italics, and is equivalent to a blank in DAX. A zero might be better, but your call.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingTy vry much
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
6 | |
6 | |
6 | |
5 |
User | Count |
---|---|
9 | |
9 | |
8 | |
6 | |
6 |