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 Phalguni
• 1,020 points
397 views

1 answer to this question.

0 votes

Hi,

You can use the following measure.

Measure 2 = CALCULATE ( [Measure 1], FILTER ( Table, Table[Year] = MAX ( Table[Year] ) ) )
This can be done with the help of DAX in power BI
answered May 10, 2019 by Avantika
• 1,520 points

Related Questions In Power BI

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,360 points
977 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
614 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,253 views
0 votes
1 answer

How do you embed dashboard using JavaScript in Power BI?

Dashboards in Power BI can be embedded ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
1,682 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,163 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,276 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10, 2019 in Power BI by anonymous
420 views
0 votes
1 answer

How do I create a line chart?

Hi, From the data mentioned above, you can ...READ MORE

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

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

answered Mar 9, 2019 in Power BI by Avantika
• 1,520 points

edited Mar 9, 2019 by Avantika 4,325 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
430 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