Forum Discussion
Format numbers in MATRIX
Hi Anonymous ,
Please refer to my .pbix file.
1. “I need only totals as totals of Actuals”
For this requirement, you can create a measure like this.
Measure = VAR x = SWITCH( SELECTEDVALUE(Sales[CountryRegion]), "dd", FORMAT( SUM(Sales[Sale 2014]), "Percent" ), FORMAT( SUM(Sales[Sale 2014]), "#, 0.00") ) VAR y = CALCULATE( SUM(Sales[Sale 2014]), FILTER( ALL(Sales), Sales[CountryRegion] = MAX(Sales[CountryRegion]) && Sales[Month] = "December") ) RETURN IF( HASONEFILTER(Sales[Month]), x,y )2. Show the border of "Variance"
This requirement is currently not possible, but you can mark ‘Variance’ in other ways.
Firsr, create a measure like this.
Conditional format = IF( MAX(Sales[Month]) = "January", "Green" )Second, add the measure to the 'conditional formatting' label.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
It depends if you need to have two different formats for the same measure, you can try like the example below.
Total Orders =
VAR C = COUNTROWS(Orders)
RETURN
IF(
C < 5 ,
FORMAT(COUNTROWS(Orders)/100,"0.0%"),
C
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Hi Fowmy ,
Thanks for your response.
My dataset is as shown below:
Allocations | m$ |
| Actual | 0.08 |
| Strategic | 0.03 |
| Variance | 0.12 |
| Funds | 3456.08 |
My output is a MATRIX and needs to be displayed as follows:
| Actual | Strategic | Variance | Funds |
| 8% | 3% | 12% | 3456.08 |
Hi Fowmy,
Thanks a lot. That works !
My values do come up as you've mentioned. But my % totals now add up, instead I need it to be displayed as follows:
Bank Funds Actuals 8% Strategic 3% Variance 5% 545 Cash Actuals 3% Strategic 4% Variance 2% 452 Total 25% I'm using the formula you'd mentioned below to get this displayed as % for Actual, Strategic and Variance and decimal for Funds
But my total needs to only add totals(Actuals)
And also, my totals come up in Bank and Cash. (I'm using MATRIX in Power BI)