Forum Discussion
Replace (BLANK) with "No Data"
Hi,
So I have a report with around 40 measures, it's basically 99% done.
I was just wondering if there was a way (without measure) to replace the default value of "(BLANK)" with a more meaningful text for the people who look at the report.
Something like "No data available" would be more meaningful to them than BLANK.
Is it possible to change this without adjusting all my measures to IF isblank, text, measure?
Thanks in advance!
Anonymous , as of now there is no such default option.
1. You can add +0 or use coalesce([Measure],0) they will force left join (you will see all dimension value
2. You can use if, same it will force left join
3. Any other formatting like "No value" (using if), you need to change the format to text.
4 Replies
If you are talking about your individual measures, you could add +0 to the end of your measures (add after you have closed off the last bracket.)
So instead of '(blank)' your measure will return a zero.
Anonymous , as of now there is no such default option.
1. You can add +0 or use coalesce([Measure],0) they will force left join (you will see all dimension value
2. You can use if, same it will force left join
3. Any other formatting like "No value" (using if), you need to change the format to text.
Thanks amitchandak and Daviejoe ,
No I don't want to adjust 40 measures just to have it show a certain text 🙂 Was wondering if there was some sort of default option where you could change what, for example, a card would say if there was a blank shown.
A 0 would not be representative of what information I would want the visualization to give.
or there's a way to set a default that you can modify in some settings.
blank is the default.
the only option is to modify each measure or column with 0 at the end or with IF that return the descriptive text you prefer
You could save that text to a measure and reuse it in all measures where you want to validate the BLANK
