Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Line Chart - show series only when one item selected

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 slic...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-jiascu-msft

 

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??

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-jiascu-msft

     

    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!

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        v-jiascu-msft

         

        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!