Can I filter a bar chart by clicking a value on the Y axis? I want it to filter itself.

[jmkeuning]

I have a bar chart where many bars are dwarfed by the larger bars. I have a slicer that I can use to filter the bar chart to a particular record, but I want the user to be able to just click the bar chart to slice itself. Then clicking the same value will remove the filter.

I effectively need to zoom in so the user can select a colored bar that will filter a table.

[foodd]

Please add your work-in-progress Power BI Desktop file, and source data in Excel format.

[rubayatyasmin]

use drill through. 

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

[jmkeuning]

From that page: "...create a destination target page... right-click a data point in other source report pages, they drill through to the target page...."

All of this is happening on one page for me. I want to filter the chart itself, not an object on another page.

[rubayatyasmin]

However, Power BI does not natively support filtering a bar chart by clicking a value on the Y axis. Here's an alternative approach using a slicer:

1. Create a slicer visual and set its data field to the same field that you're using for the Y axis of your bar chart. This will create a list of all unique values from that field.

2. Under the Format pane of the slicer, you can adjust its settings to display as a slider or dropdown instead of a list. This will allow users to easily select a value, and all visuals tied to that field will automatically update to reflect the selected filter value.

While this approach doesn't allow for direct interaction with the Y axis, it provides an intuitive way for users to filter the data in your bar chart by selecting values from the same data field.

[jmkeuning]

Is it possible to create a copy of this bar chart, which by default is filtered to show no values, and when a user clicks a value in the main bar chart, the secondary shows the selected bar only?

[foodd]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[jmkeuning]

hi foodd. here is the pbix:

https://file.io/yzksjGBYYbbL

[jmkeuning]

i forgot to add the data

Table 1

ID	Resource	Visits	VisitDate
1	This	3	1-Apr
2	That	4	1-Apr
3	Another thing	5	1-Apr
4	This	3	1-Apr
5	That	6	1-Apr
6	Another thing	4	1-Apr
7	This	5	2-Apr
8	That	3	2-Apr
9	Another thing	4	2-Apr
10	This	1	2-Apr
11	That	3	2-Apr
12	Another thing	4	3-Apr
13	This	2	3-Apr
14	That	3	3-Apr
15	Another thing	1	3-Apr
16	This	3	3-Apr
17	That	4	3-Apr
18	Another thing	5	3-Apr
19	This	3	3-Apr
20	That	4	5-Apr
21	Another thing	4	5-Apr
22	This	4	5-Apr
23	That	5	5-Apr
24	Another thing	3	5-Apr
25	This	4	5-Apr
26	That	5	5-Apr
27	Another thing	3	5-Apr
28	This	4	5-Apr
29	That	5	5-Apr
30	Another thing	3	5-Apr
31	This	3	5-Apr

Query 1

Resource	SumOfVisits	VisitDate
Another thing	9	1-Apr
Another thing	4	2-Apr
Another thing	10	3-Apr
Another thing	13	5-Apr
That	10	1-Apr
That	6	2-Apr
That	7	3-Apr
That	19	5-Apr
This	6	1-Apr
This	6	2-Apr
This	8	3-Apr
This	15	5-Apr

[jmkeuning]

Thaks Foodd, I hope this helps:

[mohamed_elayeb]

Hello, i've been trying to do this for a week, did you find a solution on how to filter a graph by itself ?