Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
Marico
Helper III
Helper III

Hiding number of rows in filter pane

Hi,

 

Wanted to know if there is any possibility or workaround to hide the number rows shown in filter section?

 

Marico_1-1748940929731.png

 

1 ACCEPTED SOLUTION
v-karpurapud
Community Support
Community Support

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.

View solution in original post

7 REPLIES 7
v-karpurapud
Community Support
Community Support

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.

v-karpurapud
Community Support
Community Support

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.

v-karpurapud
Community Support
Community Support

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.

v-karpurapud
Community Support
Community Support

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.

Elena_Kalina
Solution Sage
Solution Sage

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:

  1. Click the dropdown arrow next to "Basic filtering"

  2. Select "Advanced filtering"

  3. 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.

Nasif_Azam
Solution Sage
Solution Sage

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

  • Slicers do not show row counts next to each item.
  • You can style and position them freely, and even make them look similar to the filter pane.
  • Bonus: You can apply visual-level or page-level filters to control their data source context.

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,

  1. There's no DAX or format setting that hides counts in the filter pane.
  2. CSS tricks or custom themes don’t apply to this part of the Power BI interface.

 

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

Bibiano_Geraldo
Super User
Super User

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.