Forum Discussion
Solved
Hide graph when no data is selected
I have a table of data containing site locations, and a related line graph showing environmental times series data belonging to that site. When I select a row in the table, the line graph shows the r...
Have you tried using this measure
replace the [Your measure] in the code below with the current measure that you are using in the line graph
if(isfiltered([Site Name]),[Your measure], blank())When you use blank(), it returns no values and should leave your graph blank
Hope this helps
Nishant
More:
I've created a measure which can detect when a row is selected:
SlicerCheck = if(calculate(distinctcount([Site Name]),allselected('TakeStatus'[Site Name]))=1,"Y","N")
But how can I filter or hide data based on this?
Have you tried using this measure
replace the [Your measure] in the code below with the current measure that you are using in the line graph
if(isfiltered([Site Name]),[Your measure], blank())When you use blank(), it returns no values and should leave your graph blank
Hope this helps
Nishant
- Hi. Thanks for replying. I got it working... Something along the lines of what you are suggesting. Ive marked your answer as correct.