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
ahmedalbabili95
New Member

Quick Question About Filtering Upon Selection Capability in Power BI (Single Chart or Same chart)


I was wondering if there's a capability or a workaround in Power BI in which for example if I have a bar chart so that when I click on a bar for instance, it filters the chart to show only that bar's value, instead of just highlighting it?


I'm not talking about cross-filtering or cross-highlighting. I'm talking about a single chart here or even if we have multiple charts, I'm talking about the current chart that I'm selecting on. 

Thanks in advnace!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @ahmedalbabili95 ,

Below is my table:

vxiandatmsft_0-1717378821436.png

workround1:

You click the show data point as a table , and you will see the only bar value in the report.

vxiandatmsft_0-1717570542068.png

workround2:

you can open the data label , and When you click on the column chart, the values inside will also be highlighted

vxiandatmsft_1-1717570983220.png

The final output is shown in the following figure:

vxiandatmsft_1-1717378916018.pngvxiandatmsft_2-1717378923221.png

Best Regards,

Xianda Tang

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @ahmedalbabili95 ,

Below is my table:

vxiandatmsft_0-1717378821436.png

workround1:

You click the show data point as a table , and you will see the only bar value in the report.

vxiandatmsft_0-1717570542068.png

workround2:

you can open the data label , and When you click on the column chart, the values inside will also be highlighted

vxiandatmsft_1-1717570983220.png

The final output is shown in the following figure:

vxiandatmsft_1-1717378916018.pngvxiandatmsft_2-1717378923221.png

Best Regards,

Xianda Tang

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

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!

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.