Need Quarter % Change

[prakash_satya59]

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

[prakash_satya59]

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.

Need help

[Anonymous · Accepted solution]

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

[amitchandak]

@prakash_satya59 , You can get like This Qtr, Last Qtr, and Change %. Else you have to create static measures

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0