Forum Discussion

pyramid1's avatar
pyramid1
Frequent Visitor
3 years ago
Solved

Matrix - Total between two columns with two row header.

Hello expert, I need some help with Matrix.   Here is my sample data: I am expecting below output: While playing with matrix , I couldn't get to expected output. So anyhelp would be a...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

     

pyramid1's avatar
pyramid1
Frequent Visitor
3 years ago

Thanks for response. It seems our powerBI Desktop versions are different hence My power BI Refuse to open pbix that you attached. Which version of PowerBI Desktop you are using.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

My version is, 

 

  • pyramid1's avatar
    pyramid1
    Frequent Visitor
    3 years ago

    Thanks Kim. I was able to use pbix that you attached. Is there a way to color whole salary section and underneath columns to be in one color and whole Tax section in another color?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      3 years ago

      Hi,

      I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

       

       

      • pyramid1's avatar
        pyramid1
        Frequent Visitor
        3 years ago

        Yep that makes sense. I am doing more formatting on "Diff" column. So if value Diff-Measure (under Salary) is postive then make it green. If value Diff-Measure (under Salary) is negative then make it Red. Is this kind of coloring possible.