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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
vrafael
Frequent Visitor

Filter by bar click and make it the default view

I have a Power BI page with two bar charts. The first chart filters the second one so when I click a bar in the first chart the second chart filters accordingly.

Is there a way to set a default bar filter? I want the report landing page to open with the bar filter already applied.

 

Any help is appreciated.

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

Hi @vrafael ,

suparnababu8 , good answer!

Is this what you mean by "default bar filter"?

vjunyantmsft_0-1736905219358.png

If so, I'm sorry that your requirement cannot be met, because this behavior is called highlight, which is not a filter in the strict sense. Any save operation in Power BI cannot save the result after highlighting.

Please try the method mentioned by suparnababu8. In Power BI, only bookmarks can record the operations after highlighting, but you need to manually click to switch bookmarks after opening the report to display it.

Best Regards,
Dino Tao

View solution in original post

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @vrafael ,

suparnababu8 , good answer!

Is this what you mean by "default bar filter"?

vjunyantmsft_0-1736905219358.png

If so, I'm sorry that your requirement cannot be met, because this behavior is called highlight, which is not a filter in the strict sense. Any save operation in Power BI cannot save the result after highlighting.

Please try the method mentioned by suparnababu8. In Power BI, only bookmarks can record the operations after highlighting, but you need to manually click to switch bookmarks after opening the report to display it.

Best Regards,
Dino Tao

suparnababu8
Super User
Super User

Hi @vrafael 

 

There is no stright forward option to achieve this requirement in Power BI. But, you can achieve this with some workaround.  By using book marks concept you can achive this. 

  1. Create and setup default filter - Apply the desired filter on the first bar chart by selecting the bar you want to set as the default
  2. Create a Bookmark - Click on Bookmarks and then Add to create a new bookmark. This bookmark will capture the current state of your report, including the applied filter. 
  3. Set the Bookmark as Default 

If you follow these steps, your report will open with the default filter applied to the first bar chart, ensuring that the second chart is filtered accordingly.

 

Let me know if it works.

 

Thanks

 

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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