Forum Discussion

AnaAlbano's avatar
AnaAlbano
Icon for Helper I rankHelper 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?

AnaAlbano's avatar
AnaAlbano
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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 .