Option to change BLANK to 0 in visuals
Right now, if you plot a measure that has blank values as a line-graph, you get a gap. This makes sense in some cases, but it would be nice to have an option in the visual to change blanks to zero's (this goes also for other visuals, such as cards where you might want to show revenue of 0 instead of blank).
I know you can check in your measure with DAX if the value is 0, but it would be easier if it is a checkbox in the visual.
Jurr Kwint commented
Why is there no way to change a BLANK card to 0.......
Travis Kale commented
I should not have to do this check at the DAX layer, it should be done in the presentation layer. Why make users do stupid DAX tricks, I would prefer a check box just like Excel pivot tables.
I need to use another word in different language rather than English , we don't have such word
a lot of basic features are missing in power BI
Praveen Elango commented
Also, my line chart ignores all the filters, if I try to workaround the problem by doing IF(ISBLANK(MyMeasure), 0, MyMeasure).
Joe Anderson (Access MVP) commented
What is the workaround ?
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!