Please Provide Direction on Creating KPI Dashboard

Since you are new to Power BI, I would like to inform that it is definitely possible and may advise you to take an iterative approach.

I will recommend to start with one calculation group, with 5 Measures
which contains different formats and then add the remaining.

1. Cleanse the data and model to your needs

2. Create the measures you need

3. Get the Tabular Editor installed (Optional but recommend to ease your work)

4. Calculation Groups

I will recommend to go one after other these links, which makes you more comfortable.

Spend like 3 to 4 hours, as almost all links provide different examples using Calculation Groups.

• https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/ 
• https://www.sqlbi.com/tv/introducing-calculation-groups-in-dax-and-power-bi/ 
• https://apexinsights.net/blog/10-uses-for-calculation-groups 
  • Also, check towards the end, Full list of references
• https://community.powerbi.com/t5/Community-Blog/How-And-When-To-Use-Calculation-Groups-In-Power-BI/ba-p/1796197 
• https://blog.enterprisedna.co/small-multiples-with-calculation-groups-in-power-bi/
• https://www.youtube.com/watch?v=XCugcQ-_Zfk 
• https://blog.enterprisedna.co/creating-measure-groups-power-bi-best-practices/ 
• https://blog.enterprisedna.co/conditional-formatting-in-calculation-groups-power-bi/ 
• https://goodly.co.in/measures-in-columns-matrix-powerbi/ 
• https://blogs.perficient.com/2022/08/29/calculation-groups-in-power-bi/
• https://learn.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions 
• https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/

5. You may need two or three Calculation Groups, as you have lagging, leading indicators set