Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have raw data table in which there are about 4 rows that i want to remove which are blank in a particular column. I am choosing the column > Transform Data > Home > Remove Rows > Remove Blank Rows... but this is not working. What am i doing wrong? Also, i dont mind leaving them but how do i uncheck (blank) from the visual?
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi
I ran into a problem, am trying to build a connection with the same table. So i have the raw data table in which i have country column which has duplicates so am uploading a file with the list of the unique countries. when i connect the both, the (blank) re appears, why? I have applied filter (Blank) to that column and the Unique Country List table does not have any blank.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
It appears in the visual as (blank) with values 0, the country list is exactly the same but just doesnt include duplicates.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
You are exactly right and those are the countries i want to exclude as they will not have any values ever. that was the whole idea of having a separate table wxluding these countries so i can choose DimCountry for visuals
Sorry, you are right, the raw data includes some countries to which i will never receive any data, hence want to exclude. Is this the reason?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Got it! Thanks so much
You are going in the right direction. Just do the little workaround if you are not getting from your action.
Go to transform query editor > select the column on which you wanna remove blank values then click on the small down arrow icon to get the list of values that are available on this column> uncheck the "null" value > Save and apply this changes.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |