Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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])
select the measure and make the change here
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
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
87 | |
68 | |
66 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |