cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

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 🙂

2 ACCEPTED SOLUTIONS
Super User

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper I

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 4
Super User

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper I

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?

Super User

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Super User

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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors