Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Display chart based on slicer value

I have created two charts to display the NPS scores of clients, One is a line chart showing the NPS score over multiple years and the other is a tachometer chart to display the NPS score,

Now, if I select a client name from a slicer 'Client 1' there are three possibilities here 

  • The client's NPS score is blank (No data)
  • The client's NPS score is available for one year only, say out of years 2020 - 2023 we have the NPS score for the year 2021 only 
  • We have NPS scores for multiple years 

 

For each of the possibilities I want to display different output 

  • I have already done this , if the output is blank I am displaying no data message using conditional formatting 
  • If only one-year data is available then instead of a single dot on the chart I want to display the tachometer viz 
  • If multiple years of data are available I want to show the line chart

 

Is it possible to display or hide visuals based on conditions? I have an event date column with the all the dates and can use that to extract the year 

 

 

No Replies