Forum Discussion
Using date hierarchy and values breaks filters
Another option is to use a DAX trick to return blank for a measure where another measure has no data.
Constant = DIVIDE ( [Days to Invoice], [Days to Invoice] ) * 10In my example [Days to Invoice] is whatever measure you are showing on the bars. If that measure is blank, DIVIDE will return a BLANK and BLANK * 10 returns a BLANK which should stop it from pulling in the extra date values.
If [Days to Invoice] returns an amount DIVIDE [Days to Invoice] by [Days to Invoice] will return 1 then you multiply 1 * 10 to get the 10.
Another option is to use a DAX trick to return blank for a measure where another measure has no data.
Constant = DIVIDE ( [Days to Invoice], [Days to Invoice] ) * 10In my example [Days to Invoice] is whatever measure you are showing on the bars. If that measure is blank, DIVIDE will return a BLANK and BLANK * 10 returns a BLANK which should stop it from pulling in the extra date values.
If [Days to Invoice] returns an amount DIVIDE [Days to Invoice] by [Days to Invoice] will return 1 then you multiply 1 * 10 to get the 10.
Regrettibly, the answer is similar to this. Basically using IF statements to turn the measure into BLANK() when it is not applicable. Although the solution works, it is very frustrating to have to do this. There is clearly something else going on with my PowerBI that I am unable to diagnose properly