Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |