Forum Discussion

anne's avatar
anne
Regular Visitor
9 years ago

Removing Blank Values after Simple Filtering in DirectQuery

Hi there,   I have been trying to solve this already for some time – so far unsuccessfully. I use DirectyQuery to retrieve real time data. I want to sum over a column. The result of this is then fi...
Need Help
Tips and Tricks
malagari's avatar
malagari
Continued Contributor
9 years ago

Are you talking about how it shows (Blank) in a visual instead of 0? The trick I've seen tossed around the forums here is to add + 0 to the end of your measurement.

  • anne's avatar
    anne
    Regular Visitor
    9 years ago

    Hi Dan,

     

    thanks for your reply. Yes, I am talking about the visual (Blank). I do the filtering in the visualisation pane. The filter is a simple if-then filter which returns 0 if the condition is not met. Instead of "(Blank)", I would like to display "0" or even a short text. I have been trying several ways to achieve this, including other measures etc., but it seems that due to the use of DirectQuery there are not many options.

    I really appreciate any hint on how this can be solved since the "(Blank)" display is very misleading. It looks like there is an error in the report each time a new month starts.

     

    Best,

    Anne-Kathrin Schumann

    ProTechnology GmbH