Not out of the box. Matrix visual only supports Data bar, background fill, and font color for conditional formatting. You'll either have to create your own custom visual, using developer tool.
https://docs.microsoft.com/en-us/po...-visuals-getting-started-with-developer-tools
Or find one that's available, that'll meet your need (from MS market place, most visuals are free).
So you have custom visual already imported into your .pbix file?
If you need specific help on how to use custom visual, you'll need to tell us more info, like link to visual in market place.
Upload simplified model/raw data for faster response.
= try [people] - #"Added Index"{[Index]-1}[people] otherwise null
Pdiff = SUM(Sheet1[indP])
UpDown = SWITCH(True(),ISBLANK([Pdiff])||[Pdiff]=0,"-",[Pdiff]<0,UNICHAR(9660),[Pdiff]>0,UNICHAR(9650))
I believe the method used is image lookup table, using image url. See link for detail.
http://sqljason.com/2015/11/custom-indicators-in-power-bi-using.html
If you are ok with black up down, there are several ways to do this. If not using direct query mode. I'd recommend following approach.
1. Add index column.
2. Add custom column with following formula.
3. do same for other columns.Code:= try [people] - #"Added Index"{[Index]-1}[people] otherwise null
4. Remove index column.
5. Add measure [Pdiff]
6. Add indicator measure.Code:Pdiff = SUM(Sheet1[indP])
Code:UpDown = SWITCH(True(),ISBLANK([Pdiff])||[Pdiff]=0,"-",[Pdiff]<0,UNICHAR(9660),[Pdiff]>0,UNICHAR(9650))
View attachment 51588
Just use the same logic for any other column. Nothing changes except for column reference in functions (M and in DAX).
Matrix visual, as far as I know, doesn't support color formats for text/string. If numeric, you could use conditional formatting, but you will lose up-down indicator arrow.
Alternative is to use image uploaded to web, and use image url in table column. Then in modeling set "Data Category" to Image URL.
View attachment 51594
I don't have image url to give you demo. But if you can supply those url. I could build demo for you.
= if (try [Profit] - #"Added Index"{[Index]-1}[Profit] otherwise 0) > 0 then "Up" else if (try [Profit] - #"Added Index"{[Index]-1}[Profit] otherwise 0) < 0 then "Down" else null
Here you go...
1. In Home ribbon tool, select Enter Data and create image lookup table:
View attachment 51595
2. Add index column to original table.
3. Add custom column [Profit_i]
Code:= if (try [Profit] - #"Added Index"{[Index]-1}[Profit] otherwise 0) > 0 then "Up" else if (try [Profit] - #"Added Index"{[Index]-1}[Profit] otherwise 0) < 0 then "Down" else null
4. Remove unnecessary columns.
5. Back in model, go to created table and set Img URL column to data category "Image URL".
6. Make relationship between [Profit_i] and [UpDown].
7. You'll need to use table visual as Matrix visual does not support image URL.
8. Add columns and you are done.
View attachment 51596
Here you go...
1. In Home ribbon tool, select Enter Data and create image lookup table:
View attachment 51595
2. Add index column to original table.
3. Add custom column [Profit_i]
Code:= if (try [Profit] - #"Added Index"{[Index]-1}[Profit] otherwise 0) > 0 then "Up" else if (try [Profit] - #"Added Index"{[Index]-1}[Profit] otherwise 0) < 0 then "Down" else null
4. Remove unnecessary columns.
5. Back in model, go to created table and set Img URL column to data category "Image URL".
6. Make relationship between [Profit_i] and [UpDown].
7. You'll need to use table visual as Matrix visual does not support image URL.
8. Add columns and you are done.
View attachment 51596
that Arrow is not correct
Hm? My sample matches exactly your sample file. If something went wrong then restart and follow my instruction carefully.