Matrix Formatting

[markus123]

Hi all,

i am pretty new to Power BI and have some formatting issues. Below you can see the table, how it looks like right now.

I have created a measure for the Column Mexico, but i dont know how to add other formatting commands to this measure for specific rows.

Total Inbound Orders & Orders Received within 24 Hours should be "11"

Total Lines in Stock, Lines Counted & Lines Counted Correctly should be "88"

Result Dock to Stock & Result Stock Accuracy should be "100%"

Thanks for your help!

Kind regards

Markus

[v-kelly-msft · Accepted solution]

Hi  @markus123 ,

Modify your measure as below:

Mexico 2=If(MAX(Gesamt[VALUES])="Result Dock to Stock"||MAX(Gesamt[VALUES])="Result Stock Accuracy",FORMAT(SUM(Gesamt[Mexico]),"Percent"),SUM(SUM(Gesamt[Mexico]))

If you need all the rows which contain "Result" return "100%",you may try below measure:

Mexico 2=
var _search=SEARCH("Result",MAX(Gesamt[VALUES]),1,0)
Return
If(_search>0,FORMAT(SUM(Gesamt[Mexico]),"Percent"),SUM(SUM(Gesamt[Mexico]))

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@markus123 , if Result Stock Accuracy is  a measure, make sure it marked as % column

[markus123]

@amitchandak "Result Stock Accuracy" is not a measure, it is just a row out of my data source (excel)

[Nimai123]

Hello @markus123 

If it's just a row or a column out of your data set, then to convert it to percentage follow the below steps

• Click on the desired column or a measure you want to convert.
• Then in the formatting tab click on the percentage icon

Supporting Document to help you understand

https://geekdecoders.blogspot.com/2019/12/how-to-show-percentages-in-power-bi-bar.html

Converting to Percentage 

Regards,

IF YOU LIKE MY ANSWER PLEASE GIVE KUDOS AND IF MY ABOVE POST HELPS YOU TO SOLVE YOUR PROBLEM ACCEPT IT AS A SOLUTION. 

[markus123]

 Hello @Nimai123 ,

i need different formattings to different rows of the same column. Please find below my data source and i want to have the Columns Mexico & KR - DyStar in Power BI Matrix exactly like this.

Currently it i shown like this:

Thank you

kind regards

Markus

[Nimai123]

Hello @markus123 

Can you send me your sample file so that I can implement on my end?

Thanks