cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mibu
Microsoft
Microsoft

Growth up and down arrows in Tables/Matrices like in Excel

Hi Everyone,

 

Is there a way to display growth data/calcs in Power BI in Tables/Matrices like is possible in Excel:

 

Capture.PNG

 

Thanks!

mibu

1 ACCEPTED SOLUTION
v-lid-msft
Community Support
Community Support

Hi @mibu ,

 

We can just add Condition format icon on your measure in table/matrix to meet your requirement:

 

22.PNG23.PNG24.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-lid-msft
Community Support
Community Support

Hi @mibu ,

 

We can just add Condition format icon on your measure in table/matrix to meet your requirement:

 

22.PNG23.PNG24.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@v-lid-msftThanks so much!  Super helpful.  best, mibu

Hi @v-lid-msft!  Thank you for the feedback!  Okay, I see "Icons" as an option for Tables...  but not for Matrices (only "Background color" as an option for matrices).  This is great.  Is there a way for the "Total" values to adopt the formatting as well?  Right now, the "Total" formatting does not pick up the line item formating.  Thanks!

v-lid-msft
Community Support
Community Support

Hi @mibu ,

 

Based on my test, value field in Matrix visual can add the icon condition format but icon format in total is not supported yet currently . You can come up a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

2.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User IV
Super User IV

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors