Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a Measure and it's calculating correctly, Initially I've a requirement from user to always display only one Decimal UP on a Matrix Visual. so I've used ROUNDUP([SalesAvg],1).
But the isue is in the Matrix Visual, when I drilldown there are so many scnearios value is like 0.001, 0.04, 0.07 and because Decimal as 1 in the Modeling tab, it is defaulting to 0.1 (UP) always.
But in these scenarios User wants to display 2 decimals instead of 1.
Is there a way to define number of decimals conditionally like something below.
IF( [SalesAvg] < 0.1, ROUNDUP([SalesAvg], 2)
, ROUNDUP([SalesAvg], 1 ) )
then I selected Format--> General, Decimals--> AUTO (if I select Format as 'Decimal Number' there is no AUTO option.)
But this statement is always displaying 2 decimals.
Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
Don't know what is the upper level of the matrix but you should place a measure similar to the one below replacing the Column name with the lowest level:
Measure = IF ( HASONEFILTER ( 'Table'[cat2] ); FORMAT ( ROUNDUP ( [SalesAvg]; 2 ); "0.00" ); FORMAT ( ROUNDUP ( [SalesAvg]; 1 ); "0.0" ) )
This will make the 2 decimal and format with the number of decimal places you need.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Don't know what is the upper level of the matrix but you should place a measure similar to the one below replacing the Column name with the lowest level:
Measure = IF ( HASONEFILTER ( 'Table'[cat2] ); FORMAT ( ROUNDUP ( [SalesAvg]; 2 ); "0.00" ); FORMAT ( ROUNDUP ( [SalesAvg]; 1 ); "0.0" ) )
This will make the 2 decimal and format with the number of decimal places you need.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |