Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
i want to check every column of my report for whether that column conatins value or not,,,if blank means i want add a default value intead of it...IF the column contain blank is type ( number...put 0, decimal number means 0.00, text type means put "0").How can i do that?i have almost 100 column in my report
Solved! Go to Solution.
@nisha_deepak , In power bi isblank can be used to check blank in DAX and null in power query
New column like
if(isblank[col1]),0,[col1])
or
if(isblank[col1]),0.0,[col1])
Power Query
if [col1] = null then 0 else [col1]
refer: excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/
You should be able to use a custom format string to display your column in the desired format.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@nisha_deepak , In power bi isblank can be used to check blank in DAX and null in power query
New column like
if(isblank[col1]),0,[col1])
or
if(isblank[col1]),0.0,[col1])
Power Query
if [col1] = null then 0 else [col1]
refer: excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/
i got integer value as o for the blank column.But for decimal number having blank value i can't apply value as 0.00.
i try this...
Hi @nisha_deepak ,
Firstly, it can't exist multiple data types in the same field. What's the data type of field [column1]? How did you set the data type of new calculated column with formula if(ISBLANK([column1]),0.00,[column1])? If the data type of [column1] is numeric type, you can set the data type for your calculated column as below screenshot:
Best Regards
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |