Calculation Groups and Formatting in a Matrix Visual

[Sullyball]

I am seeking to display a matrix visual where the different Key Performance Indicators (KPIs) are displayed with the appropriate aggregation and the appropriate format. I've almost cracked it but am forced to display the format names to get the matrix to work. The top visual is how I want to layout to look but it does not have the correct formats for the measure. The bottom visual has the correct formats but forces me to display the name of the aggrigation group.

Top: right layout wrong format, Bottom: right format, wrong layout

Each of the calculation items the code is similar - here's the one for currency:

IF ( SELECTEDVALUE ( 'KPI List'[Format] ) = "currency", SELECTEDMEASURE (), BLANK () )

I created a seperate table with each of the KPIs listed and the format I want to display and Joined this to my data table. While this is dummy data, in the real business scenario I have many more KPIs and records by date, hence the need to keep the matris as neat as possible

I tried adding the calculation group as a filter for the visual but it only displayed correctly when I chose one calculation item. Choosing more than one caused the numbers to disappear. Amy assistance appreciated.

[v-xuxinyi-msft]

Hi @Sullyball 

SELECTEDMEASURE is calculated for Measure in context, can you provide the formula for the corresponding Measure? If so, please provide the sample data so that we can help you better. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu