Having managed to get a dynamic slicer to work I'm now facing a different issue.
Whilst the dynamic slicer is picking up the data through the measure, it is no longer splitting this by legend. E.g- I am seeing total data, however the graph is no longer telling me where the numbers are coming from, simply the total. I believe it is to do with the way the relationships are setup but I cannot make it work. I setup a separate geographic table and linked it in, however when it add it to legend it simply returns 'blank'. Thoughts?
I am not clear about your data structure and your design, I can't reproduce this in my environment. So if possible, could you please inform me in details(such as your sample data or your current design and your expected output)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support. Best Regards, Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hiya figured out why that bit wasn't working. It was to do with the way the data was setup which I have corrected.
Linked to this is the issue with slicers.
I have three separate slicers as follows:
Divided by size of location
I can get the product slicer to work as follows:
Product selection = SWITCH(TRUE(),
VALUES('Product selection'[Product])="A",'Product A'[Product A Sum],
VALUES('Product selection'[Product])="B",'Product B'[Product B Sum])
However my issue is I need to also link it in with the other two slicers as the visual will need to change depending on what is selected. Can you please advise how to craft an (IF?) statement that would allow me to do this?