Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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,
User | Count |
---|---|
84 | |
77 | |
75 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
45 | |
43 |