Fix Blank Values in Power BI

[@GoodlyChandeep]

Happy Diwali, everyone! 🎉 Enjoy 10% off on all my courses with the code Diwali10. Hope you have a wonderful Diwali :) Download the Power BI file - goodly.co.in/blank-values-power-bi-visuals How to fix Incorrect Totals in Power BI - kzbin.info/www/bejne/r6iTgnurbrtni7Msi=e2Tn77tROKu2Sslp

[@ExcelWithChris]

Brilliant as always!! Thanks from South Africa.

[@chrism9037]

Outstanding Chaneep! This is awesome

[@michaelhudson2375]

Thanks Chandeep 🙂 I used this at work today. Your content is great!

[@emilmubarakshin49]

Excellent video on the important topic - thank you Chandeep!

[@mauryavijai]

Very useful Chandeep.

[@IvanCortinas_ES]

How good you are...!! Thank you Chandeep!!!

[@stevedavis2541]

Great explaination and presentation

[@larmondoflairallen4705]

Great video! A twist on this issue is that the "(blank)" might not be in the table/column that is showing the (blank) value. I had a "many" table joined to a "Region" and "Program Type" lookup table,. The slicer from the Region table showed a (blank), even though all of the values for that field were found in both tables. I used your nifty "EXCEPT" method to query each of the joins and found that the missing items were in the *other* dimension table. Weird.

[@shyjumathew07]

Excellent !!!

[@meriamhaq123]

Great video

[@kkravch]

thanks a lot. I just was working with data verification in my models, so it was very timely... :) On a different note, if one works in Excel, we cannot really easily create new tables in the data model, any suggestions?

[@larmondoflairallen4705]

I think you have to use the calculated column method if you are in Power Pivot.

[@kkravch]

@@larmondoflairallen4705 one of the options we can create a similar table in the power query which should also work, but it is not DAX anymore... :)

[@darins]

Brilliant!! Data is filthy. Thank you!

[@manojkumar-pp5zb]

I need to remove pincode alone from address in the columns and there are 20000 line entries (I e rows) in a excel.how would I do that and it is also raw data is not organised. Any formula in excel to remove the pincode from the same irrespective of the pincode position in the address.

[@sass520]

Can somebody after using except. How is it going to solve the blank value problem

[@zorankrekic3006]

Nice, but I have problem with blank in slicer, in desktop in slicer I see all brands, when publish report then in brand slicer i have blank, i have tested tables and it looks all fine, also in slicer filter select only brands, blank is not selected, after publishing again in prod version blank exist. I can not find why. Exist some another test which i can check online in dataset? best regards

[@eslamfahmy87]

+1

[@omgrubicon6328]

Hi, how can I reach you.

[@GoodlyChandeep]

[e-mail]

[@arjunindia990]

Just use matrix and use pivots to see whether which value as blank , no need to do all this shit😂😂

[@KishanSingh-tk6sg]

Bro try to explore more , in matrix how will you handle large amount of data ????

[@arjunindia990]

@@KishanSingh-tk6sg just simple logic no need to do this all shit follow me here in the steps ( Step -1 create a matrix in that put product id from product table in rows and in values put product id from sales table as count )( step 2 Check the count if its zero then there are ids which are not present in the sales table ) (step -3 suppose if any category is marked with product id and that product id is not present in the sales table the it will show as blank , need to remove those blank : to do that just make a measure with total sales made and keep that in filter exclude 0 in that ) done .

[@eslamfahmy87]

Hello chandeeb community..if any one know how we can work with the blanks at the slicer ?