Forum Discussion
Line Chart - show series only when one item selected
Hi Anonymous,
Try this measure, please. You don't need to change the "Cross Filter Direction" this time.
Places (M) 2 = IF ( ISFILTERED ( Courses[campaignid] ), SELECTEDVALUE ( Courses[Maximum Attendees] ), BLANK () )Best Regards,
Dale
Microsoft EmployeeHi Anonymous,
Can you share a sample, please? Because we need the model structure. How does the event connect with these columns? Is [Places(M)] a measure?
Best Regards,
Dale
Hi v-jiascu-msft,
Sorry for slow reply.
I've made a sample. Yes Places (M) is a measure.
https://drive.google.com/open?id=1tVQKBv9T7eCx1A5eUDIV4LfTmaDrD7BX
Appreciate your help.
- v-jiascu-msft
Hi Anonymous,
Based on your model, you just need to change the "Cross Filter Direction" to Single. It will work. Please refer to the snapshot below.
Best Regards,
DaleThank you, yup that certainly gets the Places line functioning as I'd hoped, but the time axis is now behaves incorrectly.
It should/was showing from creation date of first associated booking until the last for the selected course. Now it appears to be selecting the first and last for the entire table??
- v-jiascu-msft
Hi Anonymous,
Try this measure, please. You don't need to change the "Cross Filter Direction" this time.
Places (M) 2 = IF ( ISFILTERED ( Courses[campaignid] ), SELECTEDVALUE ( Courses[Maximum Attendees] ), BLANK () )Best Regards,
Dale