Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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.
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!
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
104 | |
87 | |
73 | |
66 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |