How do you change the tables in chart filters

0 votes

I am working on a report that shows 3 different figures and a bar chart with some slicers 

The Table is shown below

A B C D

A1

1 9 20

A2

2 8 20

A3

3 7 20

Measure 1 - C/D 

Measure 2 - Calculate( Measure 1, AllExcept('Year'))

Measure 3 - Calculate( Measure 1, AllExcept('B'))

And the Bar Chart has  X Axis - B , (Drilldown A) 

Y Axis - Measure 1

If I use slicers the figures are changed correctly but if I select the bar chart, Measure 2 does not show the correct number 

How do you make Measure 2 to be able to change based on the chart 

May 10, 2019 in Power BI by anonymous
630 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
0 answers

How do you handle complex relationship-based calculations when multiple tables are involved in a DAX query?

How do you handle complex relationship-based calculations ...READ MORE

Oct 29 in Power BI by Evanjalin
• 5,530 points
38 views
0 votes
0 answers
0 votes
1 answer

How do you handle complex relationship-based calculations when multiple tables are involved in a DAX query?

In Power BI, working with complex relationship-oriented ...READ MORE

answered Oct 30 in Power BI by pooja
• 4,690 points
51 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,233 views
0 votes
1 answer

How do you create visualizations in Power BI?

Visualizations in Power BI Visuals are the end-result ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
963 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
1,596 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

answered Apr 10, 2019 in Power BI by Avantika
• 1,520 points
699 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered May 2, 2019 in Power BI by Avantika
• 1,520 points
2,419 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 3, 2019 in Power BI by Avantika
• 1,520 points
2,622 views
0 votes
1 answer

How do you change the tables in chart filters?

Hi, You can use the following measure. Measure 2 = ...READ MORE

answered May 10, 2019 in Power BI by Avantika
• 1,520 points
621 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP