Forum Discussion
How to hide header column in Matrix visual.
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.
Hi,
See if my solution in the attached file helps.
8 Replies
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
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi,
See if my solution in the attached file helps.
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?
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.
Thank you it helps a lot to do the activity.
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 ?
