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

 

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!

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

It's my pleasure. I'm glad you can benefit from the community.

 

Best Regards,
Dale