Forum Discussion
Format numbers in MATRIX
I'm loading data from a datasource and using MATRIX for output. I need some values to be displayed in decimal numbers and some values to be displayed as %'s. Is this possible?
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.
14 Replies
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
Anonymous - Very dependent on what you are doing, if the two different formats are different measures/columns or not. You may find some success using FORMAT but that turns things to text. The technique here might also help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
