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
