I have created a summary report and added that report to the dashboard. When i am trying to add a filter on dashboard i am getting formula field of opportunity in filter option. And also not getting any text filed in dashboard filter.

  • you should use edit and amend you question with more details including screen shot and the specific fields you are seeing/not seeing and their types – cropredy Feb 1 '17 at 16:36

Salesforce currently doesn't support formula field in dashboard filter:

There are some things you can’t do with dashboard filters.

  • Filters can’t be added to dashboards that contain Visualforce or s-control components.
  • It’s not possible to filter on bucket fields. However, it is possible to use a report filtered on a bucket field on the dashboard page.
  • Filters aren’t applied when you schedule or email a dashboard.
  • You can’t filter data on a joined report in dashboard view or add a filter to a dashboard that only has joined reports.
  • You can’t use custom formula fields in a dashboard filter.
  • In Lightning Experience, you can’t edit filtered dashboards, which means you can’t add new dashboard filters. (You can change existing filters while viewing the dashboard, though!) Switch to Salesforce Classic to edit filtered dashboards.
| improve this answer | |

Salesforce can add formula field on Dashboard Filter.

How :

1) Make sure Field Level Security of that formula field is visible to all intended parties

2) Make sure to add the formula field to the specific custom report type of the report you are adding to Dashboard

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.