Measure outside column hierarchy in Matrix visual

[mukul_jain]

Hi All,

I have this requirement which is sort of a mixture of a table and a matrix. I tried many links but none shows any thing sismilar. basically I have some measure/value that I want to show under different category/column but there are some values that I just want to show the total and not split by column in the matrix visual. It will look something like this (focus on Current WAC & Total Value measure which are not split by column in a matrix)

[mwegener]

Hi @mukul_jain ,

check this out.

https://community.powerbi.com/t5/Desktop/Show-or-Hide-Pivot-Table-Column-Conditionally/m-p/872598#M4...

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mukul_jain]

Hi @mwegener ,

I really appreciate the approach that you have shared, but it is still not what I am looking for. In my case, there is no condition (there can be n locations as per the sample format that I have shared) that can be used for showing a particular value. I need a separate column which does not follow the hierarchy.

[mwegener · Accepted solution]

Hi @mukul_jain ,

i thought you can create something like this...

You may download my PBIX file from here.
Hope this helps.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[amarines]

Excellent Solution, to add data at the end or outside the hierarchy of columns in the visual matrix, this solution has worked perfectly for me.
This approach is laborious to implement and the complexity of each particular case.
It cost me a lot of time and work but in the end it was worth the effort.

The following image shows the result obtained and that is exactly what I had designed in SSRS.

If it is a lot of effort, especially when it is the first time, for the second or third report the design time in the part of the data model and in the DAX coding is reduced.

I hope that in the future this will be implemented and integrated in some way in some visualization.

Thank you very much for your input @mwegener , Regards

[mukul_jain]

Hi @mwegener,

First of all, Kudos for the solution that was beyond expection!!

However, I noticed that you have intentionally kept a blank row in your location table, which shows up under the two separate header ('Current WAC' & 'Total Value') and solves the purpose in your case. However, in my case it is not the case as it is a predefined dataset from a client and I cannot intsert a blank row in that and Hence, not able to replicate the solution. If you can help a bit with that as well, it would be great!!

I have still marked as a solution because it is almost the solution that I was looking for. Cheers!

[dax]

Hi mulul_kain, 

According to your description, it seems that you want to add an column which is outside column group in Matrix, right?  As I know, current  Matrix visual can't support add outside column in it, I suggest you could try to use SSRS to achieve this goal . Or if you are professional in R , you could try to create custom visual to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mukul_jain]

Hi @dax ,

SSRS is out of scope for my requirements. I will try R option, but I am new to that so might not be able to do so. Thanks for the support 🙂