Remove Data limit filter in Focus mode

[Jaykumar31]

Hello,

I have set a data limit filter of 10 in the Power BI bar chart. However, when a user clicks on focus mode, this fixed data limit should be removed, allowing all vertical bars to be displayed.

Could you please guide me on how to achieve this?

[Ritaf1983 · Accepted solution]

Hi @Jaykumar31 

Focus mode in Power BI doesn't override or change any filters applied to the visual. If your bar chart is limited to showing only the top 10 items, this limitation will remain even when entering focus mode — because it's part of the visual's definition, not a behavior related to focus mode.

If you'd like users to see all data when they want a closer look, I recommend an alternative approach:
Create two visuals — one small and limited to the top 10 items, and another larger one that shows all data with no limit.
Then, use buttons and bookmarks to toggle between the two.

You can watch this short tutorial on how to swap visuals using bookmarks:
Switch between visuals in Power BI using bookmarks

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[grazitti_sapna · Accepted solution]

Hi @Jaykumar31 

Power BI does not natively support dynamic changes to the “Top N” filter or data limit when switching to Focus Mode directly. However, you can work around this limitation using Bookmarks, Selection panes, or dynamic measures with slicers or parameters.

Steps to Dynamically Control the Data Limit (Top N)

1.Create a Parameter Table

Rename this table to something like TopNControl where values can be 10,20,50... and rename this field as
Show Top N

2. Create a Slicer
Drag the Show TopN field from the TopNControl table into a slicer on your report.

3. Create a Measure for Ranking
SelectedTopN =
VAR SelectedValue = SELECTEDVALUE(TopNControl[Show Top N], "All")
RETURN
    IF(SelectedValue = "All", BLANK(), VALUE(SelectedValue))

Then create ranking measure and apply filter in the visual using the SelectedTopN measure too.


🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[Jaykumar31]

Thanks for the reply. Yes, this is one of the workarounds using the slicer option. Since there is no direct built-in option available and the user does not want to display the option in the slicer, I may go with a toggle button to switch between filtered and unfiltered visuals

[Ritaf1983 · Accepted solution]

Hi @Jaykumar31 

Focus mode in Power BI doesn't override or change any filters applied to the visual. If your bar chart is limited to showing only the top 10 items, this limitation will remain even when entering focus mode — because it's part of the visual's definition, not a behavior related to focus mode.

If you'd like users to see all data when they want a closer look, I recommend an alternative approach:
Create two visuals — one small and limited to the top 10 items, and another larger one that shows all data with no limit.
Then, use buttons and bookmarks to toggle between the two.

You can watch this short tutorial on how to swap visuals using bookmarks:
Switch between visuals in Power BI using bookmarks

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly