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 value. Is there a way to do it? I tried this way, but no success:

% Cond. = IF(([Total Employees Based on Selection])>0.01,
                  ROUND([Total Employees Based on Selection],2),
                  ROUND([Total Employees Based on Selection],0))

 

Thank you 🙂

Need Help
  • 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?

4 Replies

    • 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 .  

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey AnaAlbano ,

     

    you can use the round function to change the value, but the display in the bar chart stays the same for all numbers.

    You could do that dynamically with the FORMAT function. But that will return a string what won't be possible to display in a bar chart:

    Dynamic scaling of a measure in Power BI with DAX - What the fact.bi

     

    You could split it into multiple measures, one for 2 decimals and one for 1 decimal and then add them to the bar chart. But I'm not sure if that's worth the effort.

     

    For the same measure you cannot change the formatting by value for sure.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis