Hi Datafam ,
I am trying to filter each sheet in our dashboard with a parameter. I want to show "No data " label if the parameter values does not match with the values in Account name MASTER field. Can someone please help me to achieve this. Thank you in Advance.
Regards,
Deepak
2 个回答
Hi @Deepak Busanagari
Do the following:
- Create a SET from your Account Name MASTER --> include all values in that set.
- Create a calculation that will replace "Buyers Role" on your Marks card:
IF ([Account Name] in [Account NAME (Master) Set]) = FALSE THEN "No Data" Else [Buyers Role] END
- Adjust your filter to this:
[Account NAME (Master)] = [Account Name]
OR
([Account Name] in [Account NAME (Master) Set]) = FALSE
The other fields like color and #People Researching you can adjust as you require, the technique stays the same.
See also attached for your reference
If this helps in resolving your question, kindly mark as "select as best".
Kind regards
Steffen
