The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
Hi @taysa-lamberti ,
The current version does not support a default slicer. Maybe you can submit it as an idea.
And I suggest that you can use a bookmark to set up default filters.
Please refer to the following document.
Set Up Default Filters in Power BI - Microsoft Power BI Community
Solved: Filtered default view based on user - Microsoft Power BI Community
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @taysa-lamberti ,
The current version does not support a default slicer. Maybe you can submit it as an idea.
And I suggest that you can use a bookmark to set up default filters.
Please refer to the following document.
Set Up Default Filters in Power BI - Microsoft Power BI Community
Solved: Filtered default view based on user - Microsoft Power BI Community
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |