cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mish-793 Frequent Visitor
Frequent Visitor

Dyanamic slicer not picking up legend

Hiya,

 

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?

 

Thank you!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Dyanamic slicer not picking up legend

Hi mish_793,

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.

mish-793 Frequent Visitor
Frequent Visitor

Re: Dyanamic slicer not picking up legend

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:

 

Product Data typePresented as
ARaw dataValues
BDivided by size of locationCurrency
   

 

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?
 
Thank you!
 
 
 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,240)