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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dkdirenzo
Frequent Visitor

Change Value Format by Row-Level in Same Matrix

Hi, is it possible to change the format of Values in one column in a Matrix? For example, I need to show Rates as a % and Indices as a whole number:

dkdirenzo_0-1713282825267.png

 

1 ACCEPTED SOLUTION
samratpbi
Solution Supplier
Solution Supplier

Hi, you can create a dynamic formatting on the column.
For example, keep the value column format as General and create a simple measure on that value column.

sum val =
SUM(Dyn_Formatting[Value])
Then once you bring that measure in the visual, change the Format to Dynamic. then in the dynamic Formatting, you can use the below logic.
samratpbi_1-1713284676170.png

As you can see whole numbers are being displyed as number and percentage fields are in %.

If this resolves your problem, then please accept it as solution, thanks!

View solution in original post

3 REPLIES 3
samratpbi
Solution Supplier
Solution Supplier

Hi, you can create a dynamic formatting on the column.
For example, keep the value column format as General and create a simple measure on that value column.

sum val =
SUM(Dyn_Formatting[Value])
Then once you bring that measure in the visual, change the Format to Dynamic. then in the dynamic Formatting, you can use the below logic.
samratpbi_1-1713284676170.png

As you can see whole numbers are being displyed as number and percentage fields are in %.

If this resolves your problem, then please accept it as solution, thanks!

This is a great start! I am wondering if I can use Switch/True to add more formats? for example, if I need to show percent, decimal, and whole number - is this possible? I'm not sure how else to identify these types of number formats 

Hi,
yes, you can do. using a condition like [sum_val] = or <> INT ([sum_val) you should be able to identify whether a value is decimal or whole number. I have created the format based on the values in your example.

If this resolves your problem, then please accept it as solution, thanks!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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