Forum Discussion
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:
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.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!
3 Replies
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.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,
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!