Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |