Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rcspaiva
Helper I
Helper I

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
rcspaiva
Helper I
Helper I

 

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





😄

 

 

 

View solution in original post

1 REPLY 1
rcspaiva
Helper I
Helper I

 

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





😄

 

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors