How to Invert and Rename Groups in Your Tables

In a situation when you have different types of KPIs in your table, you can invert certain elements where that makes sense.

For example, if you’re showing Revenue and Costs within the same table, it has a completely different meaning whether the Revenue is growing versus if Costs are growing. Growing costs have a negative contribution to the end result.

IN THIS ARTICLE

  1. How to Invert KPIs/Groups
  2. How to Rename your KPI/Group

 Watch how to invert and rename groups in your tables in Power BI!

1. How to invert Groups 

Click on the down-arrow on the right side of the “Cost” measure and select “Invert”. That command will invert only the part of the table that relates to your costs. 
Zebra BI will automatically change the colors to properly signal a positive versus negative contribution.

2. How to rename any of your KPI/Group

With Zebra BI Tables you can rename your KPIs or Groups directly within the visual. 

Click on the name of your KPI and type in the new name. For example, you can change the name “Cost” to “Expenses”. Press Enter to confirm.

This is how you can now create tables where you have a lot of different KPIs with a mixed meaning (“good vs bad”) and you can do it all in just one simple Zebra BI Tables visual.

This feature was a part of the Zebra BI for Power BI 4.5 release

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us