How to hide header column in Matrix visual.

[jishnubhattacha]

I have a requirement to show month wise top 10 customer against sales along with in 11th row show "other customer " and the total sales. I am showing the sample data set 

Customer	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar
JB Pharma	10	7	8	6	9	2	21
GD Pharma	8	6	5	4	2	1	10
Ranbaxy	7	3	4	3	7	6	3
Lupin	6	5	5	4	3	4	4
East India Pharma	5	7	6	2	3	3	2
Cipla	6	3	4	5	2	3	1
Sun Pharma	7	3	5	1	4	1	1
Cadila	8	2	2	5	1	1	1
Biocon	6	1	1	1	1	2	1
Torrent	5	2	1	1	1	1	1
Others	11	12	9	16	7	8	9

The above is my objective. I have the data and I am able to do the report visual but not in a single matrix view. For top 10 I have created one matrix and do the needful and achieve top 10 customer against sales. Next I created one dax measure to filter the  sales amount more than 10 customer also achieve the others customer details but in a separate matrix. Howeverafter doing this I made two matrix visual having two  separate headers. How to overcome this I need the visual like the table I have mentioned.

[lbendlin · Accepted solution]

Filtering the top products alongside the other products in Power BI - SQLBI

[jishnubhattacha]

Thank  You  for your help. Now I am able to  construct the Matrix of monthly sales against top 10  customers along with Other customer. Also at the last column it needs a conditional formatting of showing last column values in different background colour for which I have created one DAX function and  in condiitonal formatting I  set Format Style as Field and  the field is my DAX function and applied on Values only. By this setup my objective become fulfilled.  

But now I have one question i.e.  Now one reqirement I got  that before Customer field one Index column needs to be incorporated mark 1 to 10  for top 10 customer. But When I put the index into row area it is showing index value but Other customer case is not accomplished. Is there any  way  to  do ?

[jishnubhattacha]

Thank you it helps a lot to do the activity.

[Ashish_Mathur · Accepted solution]

Hi,

See if my solution in the attached file helps.

[lbendlin · Accepted solution]

Filtering the top products alongside the other products in Power BI - SQLBI

[jishnubhattacha]

Thank you for the solution. Your reference helped me a lot to accomplish  my  requirement. Now the matrix is framed with top 10 customer with monthly sales along with other customer. Now the requirement is to introduce an index start from 1 to 10 beside customer name . When other customer is not in the matrix then by incorporating index field it is working properly. But when I put the index column with top 10 along with other customer it is not working. could you please intervene

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[GeraldGEmerick]

@jishnubhattacha Can you provide additional details? For example, sample source data would be helpful. Also, I am unclear as to exactly what you have today. Can you post screen shots or examples? Can you post your measure formula?

[jishnubhattacha]

Thank you for replying.  I will be get in touch  with  you regarding other problems which  I am currently facing. However regarding this solution I already have a work around by myself and by other replies it will be fruitful. It is a gratitude to see my query.