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 in Power BI by Phalguni
• 750 points
9 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 by Avantika
• 1,060 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
• 35,750 points
38 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 in Power BI by Phalguni
• 750 points
24 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 in Power BI by Phalguni
• 750 points
24 views
0 votes
1 answer
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 in Power BI by Avantika
• 1,060 points
27 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 2 in Power BI by Avantika
• 1,060 points
23 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 in Power BI by anonymous
6 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 in Power BI by Avantika
• 1,060 points
14 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 8 in Power BI by Avantika
• 1,060 points

edited Mar 9 by Avantika 34 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 in Power BI by Avantika
• 1,060 points
16 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.