Decimals Conditional Format

[AnaAlbano]

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 🙂

[Fowmy · Accepted solution]

@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:

[Fowmy · Accepted solution]

@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 · Accepted solution]

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]

@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]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic