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.
@Anonymous you can do this in two ways, 1) In query editor 2) Using new calculated measure
1) In Query editor:
1) in your power bi desktop click on edit queries
2)select column right click on it
3)choose replace value
4)enter "null" in find value in "replace value enter "0"
5)close and apply
you should see "0" wherever you have nulls in that column
2)Using new calculated measure
Create new measure using following code
Sales_WO_Blanl = IF(ISBLANK(Sheet2[SalePrice]),0,Sheet2[SalePrice])
use this as a card . FYI see the attched PBIX
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |