Forum Discussion

mukul_jain's avatar
mukul_jain
Frequent Visitor
6 years ago
Solved

Measure outside column hierarchy in Matrix visual

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)

Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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.

9 Replies

    • mukul_jain's avatar
      mukul_jain
      Frequent Visitor
      6 years ago

      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's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        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.