Forum Discussion
Solved
Using date hierarchy and values breaks filters
I posted a question on this yesterday for a different dashboard but saw this extremely frustrating problem reoccur on another dashboard with some more information which might help diagnose the proble...
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.
Not sure why you are seeing the different behaviour from your coworker but you should be able to use the Analysis formatting to add your constant line instead of using a measure.