Forum Discussion

AtulsDream's avatar
AtulsDream
Frequent Visitor
2 years ago
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.

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.

Need Help
  • AtulsDream's avatar
    AtulsDream
    2 years ago

    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

2 Replies