Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sullyball
Regular Visitor

Calculation Groups and Formatting in a Matrix Visual

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 layoutTop: 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.

1 REPLY 1
v-xuxinyi-msft
Community Support
Community Support

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.