Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am trying to plot a series of data in a line graph that only shows when I'm focussed on an individual event.
I found this post - Visualisations blank until something selected in a slicer to be very helpful and I feel like I'm 99% there.
The trouble I'm having is when I haven't selected an event, the series (Places (M)) plots a count on a few of the dates, I believe this is because there is only one event present on that date.
I've tried a few combinations of the formula in the link, also using SELECTEDVALUE. Can anyone help me with correct method of filtering to ensure Places are only given when I explicitly select a single event only?
Solved! Go to Solution.
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
Hi @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.
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,
Dale
Thank 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??
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
That works in the example but not in my actual model.
I will see if I can figure out why, if only my brain worked as well as yours!
Hi @Anonymous,
I attached the file in the attachment. You can download it and find if something is wrong.
Best Regards,
Dale
I got it!
I wasn't using [campaignid] in my actual model as I'm using a sensitive field not included in the example.
I simply changed the ISFILTERED reference to the appropriate column and it's now working 100% as I'd intended.
Thanks very much for your help, it's really great to not only have this as a resource but to receive such prompt replies!
It's my pleasure. I'm glad you can benefit from the community.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |