Forum Discussion

YannDV's avatar
YannDV
Frequent Visitor
4 years ago

Why doesn't my visual drill down when I filter ?

Hi Community!   Here's my problem, I am doing a simulation financial reporting and I dont understand why my visual doesn't drill down when I filter the client.  Here is the situation, on the top l...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

YannDV , if you select something on slicer say customer or SubCustomer and you want the axis to change based on that, I doubt that is possible as of now.

 

You can use the bookmark to change the axis, but that will not work in sync with your slicer

YannDV's avatar
YannDV
Frequent Visitor
4 years ago

But can you explain me why it does that ? 

Because even if it's measures and not columns, I dont get why it filters for subcustomer, mold and article but not for customer (well, it filters, but show all the other customers with 0 which is kinda useless) 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi YannDV ,

     

    Please try to replace 0 with blank in your measure. And set disable "show items without data".

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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