Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Decimal Places

Hi,   I am currently dealing with an issue whereby I want the number of decimal places for a measure be dynamic.   The use case is, if I select Option A in a slicer, the measure shows 2 decimal p...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    It seems impossible to make the number fields show with one decimal place and two decimal places at the same time if you still want to keep its data type as Numeric type...

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the suggestion. I have tried this, but when I toggle to Option B, I am left with trailing 0's.

 

E.g. If Table[Slicer] = "B"


My values will be:

9.80

8.40

3.30

 

And so on. I need them to be 9.8, 8.4.... 

This is when the number of decimal places for the filed formatting and the matrix formatting are both auto.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

It seems impossible to make the number fields show with one decimal place and two decimal places at the same time if you still want to keep its data type as Numeric type...

Best Regards

Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

     

    Thanks for the straight answer. I am currently using a workaround solution with one matrix column containing text with dynamic decimals, then another column with numeric values for the data bars (without data labels). Obviously not an ideal solution.

     

    Would you recommend submitting this as a feature request?