Forum Discussion
Replace (BLANK) with "No Data"
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.
Super UserAnonymous , 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.
jairoaolImpactful Individual
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