Forum Discussion

Aidenifyable's avatar
Aidenifyable
Frequent Visitor
2 years ago
Solved

Drill-through "Complex filter applied" causing no data to appear?

Hello All,  I have hit my head against the wall with this error occuring on a report I created that utilizes several drill-through pages to enhance the report. The reason that it is frustrating me...
Need Help
  • Aidenifyable's avatar
    Aidenifyable
    2 years ago

    Thank you for your reply,

     

    So I was able to solve the issue as there were two underlying problems with logic that I had written within the Dax. But primarily what happened was that I had a filter on the visual that was removing values with "0" and my DAX measure was turing (Blank) values into "0". What happened was the (Blank) column would show up, but all the values were assigned "0" and thus when using the drill through, all the values were removed. I changed the filter on the visual and it started working!

     

    Thank you again!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Aidenifyable ，

 

The “From Source Visual” box appears only when you have cross-filtering between visuals. Check if the cross-filtering behavior is consistent across your drill-through pages. If not, investigate any differences in the visuals or relationships.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.