Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Ahmad7886
Frequent Visitor

handeling 0 value in power bi table

I am using power table widget, for some years, data is not available. instead of showing 0.00, i want to show "Data is not available". how to do?no_data.png

7 REPLIES 7
Ahmad7886
Frequent Visitor

i ahve created a column, before creating new column i converted the Amount into text. it works, but shows numbers like 3.547934879496. however i needed only two decimal placed

New_Column = if(or(Sheet1[Amount]="0", isblank(Sheet1[Amount])), "NA", Sheet1[Amount])

aj1973
Community Champion
Community Champion

@Ahmad7886 

select the measure and make the change here

aj1973_0-1691668684003.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

eliasayyy
Super User
Super User

create a new measure 
if( OR( [ratio] = 0 , ISBLANK([ratio])) , "Data Not Available" , [ratio])

ratio filed is a numeric field, so its not accepting string "Data Not Available".

Can you please show me the measure you made?

first i converted numeric filed to text, which shows numeric values like 3.1246984664785. 

new_col = if(or(sheet1[amount]="0", isblank(sheet[amount])), "na", sheet[amount])

this create a new string column with many decimal places

aj1973
Community Champion
Community Champion

you need to creat a measure for this sheet1[amount], 

Amount = SUM(sheet1[amount]), change its format like in the image above and then replace into your measure new_col

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.