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.
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)
Anonymous
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
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 🙂