Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello, i have a bar chart visual showing a number of locations and record information:
And i want to use the location in the table above to filter the graph visual below. When i click on a location is does change the values on the chart (2 in January and 2 in april) but the visual bars do not change. The visual are showing total number of records for each month:
How can i get the orange bars to change as well to reflect the number or records?
thanks
Roger
Hi @rogerdea
It seems you may try to create measure with ALLSELECTED function for your chart.
https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
Regards,
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |