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?

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost 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