How to setup decimal points dynamically for same column

[AtulsDream]

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.

Please find below image for reference.

The issue is, Need to setup the decimal values dynamically after interger. 

For Example: Value column will have 0 decimal for first 2 rows and 1 decimal for next 4 rows and 2 decimal for last row.

Please help.

Thanks.

[danextian]

Hi @AtulsDream 

Please try using dynamic format strings:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings 

[AtulsDream · Accepted solution]

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