Dropdown list in filter not displaying in the public link

Get Help
1

I created my dashboard and the filter for district is working as expected in the sofware. (showing the dropdown list)

image
image341×510 8.73 KB

However, when I access the public link, I am unable to display the dropdown list. We need our reports to be embedded and filtered by a value of the filter, but I am not able to achieve this if is not displaying the values.

image

is it a bug? or what can be happening?

2

What version are you running? And are you linking any filter together? Or the dropdown is automatically generated via the table column?

3

We are using metabase cloud v1.49.18.
The dropdown is generated when connecting to the column. (Filter is district, I have a column named district too).

4

Can you share a screenshot how you are linking it int he dashboard and the settings of the filter itself please

5

Yes, here it is.

image
image1578×722 30.6 KB

6

and what is the question definition?

You seem to be using some implicit joins there

8

Wow that massive ... If you go back to the dashboard and click on edit here how are you populating the dropdown there? Cause i don't think its by a connected field:

image
image1690×788 67.3 KB

You have too much going on I think hehe ... Are you adding the FK constraint in the Admin -> Table Metadata?

9

The filter is populated from connected fields

image

And all the ids that are not PK are set as FK.

10

I replicate the dashboards in different levels:

  • region: is grouping by district and account and it is working ok (displaying options in metabase, public link and embed link)
  • district grouping as the picture (district, region and account) or location level grouping by location, district, region and account are not displaying options in the filter (not public link, not embed)

Both are the same questions, I am just changing the group by.