Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

MATRIX multi columns: change order

Hello everyone

Please I would like to build a matrix under BI as the following:

 

 KPI 1  KPI 2  KPI 3  
 JANFEBVARIANCEJANFEBVARIANCEJANFEBVARIANCE
A         
B         
C         
D         

 

For the moment, this is what I get:

 JAN  FEB  
 KPI1KPI2KPI3KPI1KPI2KPI3
A      
B      
C      
D      

 

Please I need your support to:

1-change the order of "Months" and "values".

2- add a measure of the variance between FEB & Jan v for each value. Thanks in advance

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello It's okey, I figured out how to do it. I created new measures: some for FEB and other for JAN. I used the formulas "Calculate" & "Filter".

    Thanks

4 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Just exchange the order of Month and KPI on "Columns" in Matrix Fields.

     

    Or, you can share me a dummy PBIX file and I'll test for you.

     

     

    Best Regards,

    Icey

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello It's okey, I figured out how to do it. I created new measures: some for FEB and other for JAN. I used the formulas "Calculate" & "Filter".

      Thanks

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Glad to hear that you have solved the problem by yourself. Please accept your reply as the solution. Your contribution is highly appreciated.

         

         

        Best Regards,

        Icey