cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rcspaiva Regular Visitor
Regular Visitor

Choosing data to give details on area chart

Hey guys I'm a new user on power bi and sometimes I have simple doubts that I can't solve my self.

 

 

I'll try be most clear as possible. I did this measure below expecting find only the percentage of growth for 2017 data.

 

 

Power BI.png

 

But its gave me a result that i wasn't expecting on the circulated red:

 Capturar.PNG

 

 

I was expecting just the result with green underline.

 

 

Is there a way to apply my measure as a detail just at necessary part of my data?

 

Thanks in advance !!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
rcspaiva Regular Visitor
Regular Visitor

Re: Choosing data to give details on area chart

 

After contact

 

Measure = VAR myyear = VALUES(Table6[Year]) RETURN IF(myyear = 2017, CALCULATE(AVERAGE(Table6[Value]),Table6[Year]=2017), BLANK())

 

 That was the direction what I was needing!

 

 Thx a loot @Greg_Deckler all credit for you!

 

=D

 

 

That was what I did and worked
Bing.PNG

 

 

 

Before>>> looking too ugly!

Bing.PNG

 

After >>>  one hundred times better!

 

Bing 2.PNG





Smiley Very Happy

 

 

 

1 REPLY 1
Highlighted
rcspaiva Regular Visitor
Regular Visitor

Re: Choosing data to give details on area chart

 

After contact

 

Measure = VAR myyear = VALUES(Table6[Year]) RETURN IF(myyear = 2017, CALCULATE(AVERAGE(Table6[Value]),Table6[Year]=2017), BLANK())

 

 That was the direction what I was needing!

 

 Thx a loot @Greg_Deckler all credit for you!

 

=D

 

 

That was what I did and worked
Bing.PNG

 

 

 

Before>>> looking too ugly!

Bing.PNG

 

After >>>  one hundred times better!

 

Bing 2.PNG





Smiley Very Happy