on 10 Oct 2016 22:25:48
Add to Card checking on Blank values and setting some custom values e.t. 0
Now we must create special measures with IF(ISBLANK..
But it makes 0-values fields
- Comments (55)
- Merged Idea (3)
RE: Add checking on BLANK for Cadr visual
Amazing idea!
RE: Add checking on BLANK for Cadr visual
Why is MS not commenting on this?
RE: Add checking on BLANK for Cadr visual
I think the visual should have a "hide when blank () " Option. Requires clear communication during development:
A message box should apper in the editor (1 visual is currently hidden because the value is blank and the "hide if blank" option is on.)
RE: Add checking on BLANK for Cadr visual
Also, my line chart ignores all the filters, if I try to workaround the problem by doing IF(ISBLANK(MyMeasure), 0, MyMeasure).
RE: Add checking on BLANK for Cadr visual
What is the workaround ?
RE: Add checking on BLANK for Cadr visual
I would like to also add to give the option to shown nothing or 0.
RE: Add checking on BLANK for Cadr visual
Absolutely agree
RE: Add checking on BLANK for Cadr visual
I've managed to use the workaround, but I think this is quite an important feature missing from Power BI even though it is available in Pivot Charts in Excel's PowerPivot.
The exact functionality I'm looking for is on the Pivot Chart "Select Data..." option, under "Hidden and Empty Cells".
Very useful for plotting time series against a large date dimension, where some measures are blank for certain time periods!
RE: Add checking on BLANK for Cadr visual
I agree that this should be an option for ease of use.
A workaround I have found when creating measures is to wrap in an IF statement testing for BLANK () and then using the IF statement to assign the value I want.
RE: Add checking on BLANK for Cadr visual
100% agree