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 u...
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.

  • 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
      Icon for Most Valuable Professional rankMost 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.

      • mukul_jain's avatar
        mukul_jain
        Frequent Visitor
        6 years ago

        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's avatar
      dax
      Icon for Community Support rankCommunity Support
      6 years ago

      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's avatar
        mukul_jain
        Frequent Visitor
        6 years ago

        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 🙂