Forum Discussion

AnaAlbano's avatar
AnaAlbano
Helper I
5 years ago
Solved

Decimals Conditional Format

Hello ā€“ I have a bar chart where I transformed the # in show as to % of total. However categories which there are less than 1%, I want to show with two decimals, but the others, remain the round valu...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    AnaAlbano 

    It is actually possible using a Calculation Group. I have attached a sample file below my signature.

    You need to create a calculation group and set the format string as follows:

     

     

  • AnaAlbano's avatar
    AnaAlbano
    5 years ago

    Thank you very much Fowmy! That works, but just for scenarios where there is no option to filter, correct? I added an slicer where the user could select each region, for instance, then I assume I need to create a group for each region, right?

Fowmy's avatar
Fowmy
Super User
5 years ago

AnaAlbano 

It is actually possible using a Calculation Group. I have attached a sample file below my signature.

You need to create a calculation group and set the format string as follows:

 

 

AnaAlbano's avatar
AnaAlbano
Helper I
5 years ago

Thank you very much Fowmy! That works, but just for scenarios where there is no option to filter, correct? I added an slicer where the user could select each region, for instance, then I assume I need to create a group for each region, right?

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    AnaAlbano 

    This will work regardless of any filter applied on the measure as long as you have the same condition that you need to use, in your case it is >0.01 .