Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 🙂
Solved! Go to 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:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
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:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
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 .
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
64 | |
52 | |
49 |
User | Count |
---|---|
217 | |
89 | |
76 | |
66 | |
60 |