Forum Discussion

prakash_satya59's avatar
prakash_satya59
Frequent Visitor
3 years ago
Solved

Need Quarter % Change

Dear Team   Greeting of the day.   I am trying to get result in Power BI as in given image but I am not able to do. Result is appearing in different way like % change is coming twice, total is co...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi prakash_satya59 ,

    When the columns in the matrix are not empty, each field of the value field is pivoted once, like this.

    So if you want the exact same matrix, you have to create three metrics and place them in the values of the matrix again, like this.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi prakash_satya59 ,

When the columns in the matrix are not empty, each field of the value field is pivoted once, like this.

So if you want the exact same matrix, you have to create three metrics and place them in the values of the matrix again, like this.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data