Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I want to show a trend of sales, using matrix visualizations, say of last x months or based on the user selection, But the issue is the latest months shows on the right hand side alongwith the total next to it, I wanted to show it at the start . Thank you all in advance. Warm Regards.
It shows like this | ||||||||||||||
Employee Name | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | Total |
x | 100 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 10 | 12 | 42 | 12 | 616 |
y | 40 | 50 | 60 | 70 | 40 | 50 | 60 | 70 | 40 | 50 | 60 | 70 | 12 | 672 |
z | 90 | 10 | 12 | 42 | 90 | 10 | 12 | 42 | 90 | 10 | 12 | 42 | 12 | 474 |
Wanted like this | ||||||||||||||
Employee Name | Apr-24 | Mar-24 | Feb-24 | Jan-24 | Dec-23 | Nov-23 | Oct-23 | Sep-23 | Aug-23 | Jul-23 | Jun-23 | May-23 | Apr-23 | Total |
x | 12 | 42 | 12 | 10 | 90 | 80 | 70 | 60 | 50 | 40 | 30 | 20 | 100 | 616 |
y | 12 | 70 | 60 | 50 | 40 | 70 | 60 | 50 | 40 | 70 | 60 | 50 | 40 | 672 |
z | 12 | 42 | 12 | 10 | 90 | 42 | 12 | 10 | 90 | 42 | 12 | 10 | 90 | 474 |
Solved! Go to Solution.
Hi @santoshlearner2 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can enter data.
Month-Year | Index |
Mar-23 | 14 |
Apr-23 | 13 |
May-23 | 12 |
Jun-23 | 11 |
Jul-23 | 10 |
Aug-23 | 9 |
Sep-23 | 8 |
Oct-23 | 7 |
Nov-23 | 6 |
Dec-23 | 5 |
Jan-24 | 4 |
Feb-24 | 3 |
Mar-24 | 2 |
Apr-24 | 1 |
(3) We can then create a model relationship.
(4) Select Table 2, select the [Month-Year] column, and select Sort by the Indexed Column.
(5) Create the matrix as shown below.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
You should be able to sort by months in descending order.
Hi @santoshlearner2 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can enter data.
Month-Year | Index |
Mar-23 | 14 |
Apr-23 | 13 |
May-23 | 12 |
Jun-23 | 11 |
Jul-23 | 10 |
Aug-23 | 9 |
Sep-23 | 8 |
Oct-23 | 7 |
Nov-23 | 6 |
Dec-23 | 5 |
Jan-24 | 4 |
Feb-24 | 3 |
Mar-24 | 2 |
Apr-24 | 1 |
(3) We can then create a model relationship.
(4) Select Table 2, select the [Month-Year] column, and select Sort by the Indexed Column.
(5) Create the matrix as shown below.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Perfect, thank you for your reply.
Thanks a lot
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
164 | |
132 | |
131 | |
95 | |
86 |