Forum Discussion
Solved
How to setup decimal points dynamically for same column
Hello Everyone, I am creating Power BI reports, which have multiple columns. first dimension column having fields, and other fact columns generating the data for that selected dimension rows. P...
Hello,
I have resolved the issue, I have created measures for all indivisual columns and applied the formatting to each row.
Example:
10th = SWITCH(TRUE(),MAX(Table1[DESC_COLUMN]) = "Observed", FORMAT(MAX(Table1[PERCENTILE_Column]),"#,0.0"),----- Same for all Rows -----,FORMAT(MAX(Table1[PERCENTILE_Column]), "#,0"))It resolves the issue.Thanks
Hi AtulsDream
Please try using dynamic format strings:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
Hello,
I have resolved the issue, I have created measures for all indivisual columns and applied the formatting to each row.
Example:
10th = SWITCH(
TRUE(),
MAX(Table1[DESC_COLUMN]) = "Observed", FORMAT(MAX(Table1[PERCENTILE_Column]),"#,0.0"),
----- Same for all Rows -----,
FORMAT(MAX(Table1[PERCENTILE_Column]), "#,0")
)
It resolves the issue.
Thanks