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 coming twice.
"April-June Q2", "Jul-Sept Q3" is a calculated column from date table.
I need the result exactly as in given Image.(Its excel chart)
Requesting to you please help for this.
Thanks
Satya
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
Dear Team
again for same query with new problem...please help.
I am taking blue line column and orange line column through field Parameter and that is measure (4 different measure)
Some time Q1 or Q2 or Q3 or Q4.
I want to get % change of selected column from Parameter slicer.
It could be Q1 - Q4 or Q2-Q3..etc.
Requesting to you..Please assist me for this.
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
