Forum Discussion

taysa-lamberti's avatar
taysa-lamberti
Regular Visitor
3 years ago
Solved

View filter by default

Hello,

 

I have a column chart where it shows a certain value from several different countries/organizations.
And I put a "Slicer" so that it can be possible to select which countries to view at the moment.


However, when the Slicer is empty and nothing is selected, it shows all countries together in the same chart, which can look very small when you have multiple countries showing up.

So I wanted to know if there is a way to leave a country by default.
When no filter is selected, in the chart I want only the "ALL Orgs" column to appear (red underline in the screenshot), which is the sum of the values of all countries together.

 

I know it is possible for me to do this filtering always manually, yes, but people from different countries will have access to this report, so I want it to be always checked by default, so there is no confusion or errors.

 

Summarizing: when clearing all the filters used, ONLY show the "ALL Orgs" column on the chart by default and not be filled with all countries together.

Thank you for everyone's attention and time!

1 Reply