- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Reflecting value and percentage in PowerBI Matrix
Good day,
Is it possible to display both value and percentages in PowerBI Matrix?
Each KPI either has value or percentage and needs to be represented as such in one Matrix
See excel example below:
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @michelleberkenb ,
You can create a new measure as below to replace the original value field, and its data type will be Text type... Please find the deatils in the attachment.
Measure =
VAR _sum =
SUM ( 'Table'[Value] )
VAR _selheading =
SELECTEDVALUE ( 'Table'[Heading] )
RETURN
IF ( _selheading = "PTRAs", FORMAT ( _sum, "Percent" ), _sum )
In addition, please review the following links and check if it can achieve the same requirement by creating calculation group.
Custom Data Labels in Power BI - Goodly
Creating Value Dynamic Formatting using Calculatio... - Microsoft Fabric Community
Best Regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @michelleberkenb ,
You can create a new measure as below to replace the original value field, and its data type will be Text type... Please find the deatils in the attachment.
Measure =
VAR _sum =
SUM ( 'Table'[Value] )
VAR _selheading =
SELECTEDVALUE ( 'Table'[Heading] )
RETURN
IF ( _selheading = "PTRAs", FORMAT ( _sum, "Percent" ), _sum )
In addition, please review the following links and check if it can achieve the same requirement by creating calculation group.
Custom Data Labels in Power BI - Goodly
Creating Value Dynamic Formatting using Calculatio... - Microsoft Fabric Community
Best Regards

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
67 | |
57 | |
50 | |
36 | |
34 |
User | Count |
---|---|
84 | |
74 | |
56 | |
45 | |
44 |