Forum Discussion
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 left, a tiler by Customer, SubCustomer, Mold (of the article) and article.
On the top Right, the simulation parameters.
On the bottom left, a view of the actual costs of each customer and on the left the same visual but taking into account the simulation parameters.
I don't get why when I filter with the customer, I get this :
While when I fitler with subcustomer, mold or article I get the same vizualisation for both of the visuals (which are good). Thus, the problem only occur for the first filter step (customer)
I would like to obtain the same display as the left one for the right one.
Could the problem be that the Actual Cost are referenced in columns in the data base, while the simulated costs are based on a measure?
Can someone help me ?
Thank a lot
3 Replies
- amitchandak
Super User
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
- YannDVFrequent Visitor
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
Community Support
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.