Joost ten Kattelaar on 19 May 2016 20:01:33
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.
- Comments (9)
RE: Option to change BLANK to 0 in visuals
'+1
RE: Option to change BLANK to 0 in visuals
Why is there no way to change a BLANK card to 0.......
RE: Option to change BLANK to 0 in visuals
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.
RE: Option to change BLANK to 0 in visuals
a lot of basic features are missing in power BI
RE: Option to change BLANK to 0 in visuals
I need to use another word in different language rather than English , we don't have such word
RE: Option to change BLANK to 0 in visuals
Amazing idea!
RE: Option to change BLANK to 0 in visuals
Also, my line chart ignores all the filters, if I try to workaround the problem by doing IF(ISBLANK(MyMeasure), 0, MyMeasure).
RE: Option to change BLANK to 0 in visuals
What is the workaround ?
RE: Option to change BLANK to 0 in visuals
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!