As the name suggests, a multi-kpi comparator allows you to compare multiple KPIs or measures on the same chart. This way you can dramatically reduce the clutter on your Power BI report page.
You can select what measure you would like to see in bars for example and which one should go into a line. We use calculation groups to help us with dynamic formatting so that we can format each selection as $, % or whole numbers as a user makes his or her selections.
Link to blog post and power bi model file: businessintelligist.com/2020/09/29/how-to-build-a-multi-kpi-comparator-using-calculation-groups-power-bi-dax-tutorial/
- Build Multi KPI Comparator using Calculation Groups (Power BI DAX Tutorial) ( Download)
- Use Measures as Columns Using Calculation Group in Power BI ( Download)
- How Small Multiple Visual Interacts With Calculation Groups In Power BI ( Download)
- How to Reduce # of Measures w/ Calculation Groups in Power BI ( Download)
- Power BI multi kpi ( Download)
- Calculation Groups in Power BI - Monthly Comparison | YottaCube | Kabin ( Download)
- Power BI - Matrix Visualization - move values from columns to rows ( Download)
- Using calculation groups in DAX ( Download)
- Are you still not using Calculation Groups! ( Download)
- Limiting the number of calculation items selected - Unplugged #26 ( Download)
- The Best KPI Cards In Power BI ( Download)
- How to Build Cards, Multi Cards & KPI's in Power BI ( Download)
- Using Multiple Calculation Groups Together in Power BI ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Creating custom groups using calculation items - Unplugged #24 ( Download)
