I hope that everyone is well.
I am stuck in a problem as stated in detail below. Please have a look and let me know if you any solution to that.
I have created a disconnected called Time with the below columns
I have a table that has a category, date, customer name, amount, gross margin, profits, and so on. Also, I have created a Date table and linked it in with my main table(as mentioned in the above line).
Now, I want a matrix chart in Power BI that shows like below if I select the Month(from Time column of my disconnected table)
|Prior Previous Month|15|10|5|
Similarly, for the Quarter and Year. How can we do that?
Also, it would be more good if we can replace the Previous Month text to the exact Previous Month, ie, Previous Month as of today is May 2020, so that should show May 2020 and April 2020 respectively. Similarly for the Quarter and Year one.
I want it to dynamic and always shows values based on the Time Value selected, Please help me out with this.