Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
Wanted to know if there is any possibility or workaround to hide the number rows shown in filter section?
Solved! Go to Solution.
Hi @Marico
Welcome to the Microsoft Fabric Community Forum.
In Power BI, there is no option to hide or disable the item count (number of rows) shown next to values in the filter pane, as correctly pointed out by @Bibiano_Geraldo . This is a default behavior and is not customizable using DAX, formatting, JSON themes, or any other settings.
While the filter pane always displays these counts, a practical workaround is to use a slicer visual instead. Slicers allow users to filter data without displaying row counts next to each item, offering more flexibility in presentation and layout.
Additionally, as suggested by @Nasif_Azam , you may create a calculated column with custom labels—for example, using DAX like TypeMasked = "Type: " & [Type] to format field values in a cleaner or more user-friendly way when used within slicers.
It’s important to note that these workarounds apply only to slicer visuals and not to the filter pane itself. Therefore, if you want to avoid displaying item counts, using slicers remains the most effective and recommended approach.
If this response resolves your query, please mark it as the Accepted Solution to assist other community members. A Kudos is also appreciated if you found the response helpful.
Thank you for being part of Microsoft Fabric Community Forum.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
Hi @Marico
We are following up to see if you have had the chance to review the information provided. If you have any further questions, please do not hesitate to contact us. Could you confirm whether your query has been resolved? If so, kindly mark the helpful response and accept it as the solution to assist other community members in resolving similar issues more efficiently. If not, please provide detailed information so we can better assist you.
Thank You.
Hi @Marico
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi @Marico
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @Marico
Welcome to the Microsoft Fabric Community Forum.
In Power BI, there is no option to hide or disable the item count (number of rows) shown next to values in the filter pane, as correctly pointed out by @Bibiano_Geraldo . This is a default behavior and is not customizable using DAX, formatting, JSON themes, or any other settings.
While the filter pane always displays these counts, a practical workaround is to use a slicer visual instead. Slicers allow users to filter data without displaying row counts next to each item, offering more flexibility in presentation and layout.
Additionally, as suggested by @Nasif_Azam , you may create a calculated column with custom labels—for example, using DAX like TypeMasked = "Type: " & [Type] to format field values in a cleaner or more user-friendly way when used within slicers.
It’s important to note that these workarounds apply only to slicer visuals and not to the filter pane itself. Therefore, if you want to avoid displaying item counts, using slicers remains the most effective and recommended approach.
If this response resolves your query, please mark it as the Accepted Solution to assist other community members. A Kudos is also appreciated if you found the response helpful.
Thank you for being part of Microsoft Fabric Community Forum.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
Hi @Marico
I agree with @Bibiano_Geraldo . But if you simply need to hide the counts while not requiring visibility of all distinct values in that column, you can switch the filter view mode to 'Advanced Filtering':
In the visual-level filter:
Click the dropdown arrow next to "Basic filtering"
Select "Advanced filtering"
This displays filter conditions without value counts."
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Hey @Marico ,
In Power BI, the number of rows (i.e., item counts) displayed in the Filter pane as shown in your screenshot cannot be turned off using native settings as of now. However, here are a few workarounds you can consider,
Workaround 1: Use a slicer visual instead of the filter pane
Workaround 2: Use a calculated column with masked labels: Create a new column to hide actual values and use that in the slicer.
Type_NoCount = "Type: " & [Type]
Then, use this new column in the filter/slicer this doesn't remove the count, but you can replace sensitive or unwanted text.
Those 2 workaround having some drawbacks,
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
Hi @Marico ,
As i know Power BI does not support hiding the row count directly in the filter pane UI, and there's no setting to disable this.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
68 | |
57 | |
55 | |
36 | |
34 |
User | Count |
---|---|
76 | |
73 | |
48 | |
45 | |
43 |