Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a matrix displaying multiple measures by month and dimension, like this one:
Fruit |
| Dec-19 | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 |
Apple |
|
|
|
|
|
|
|
|
|
| Measure1 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 |
| Measure2 | 210 | 209 | 208 | 207 | 206 | 205 | 204 | 203 |
Banana |
|
|
|
|
|
|
|
|
|
| Measure1 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 52 |
| Measure2 | 150 | 149 | 148 | 147 | 146 | 145 | 144 | 148 |
I'd like to add the comparison to the beginning of the year and the last month in the same table:
Fruit |
| Dec-19 | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | vs Dec 2019 | vs Last Month |
Apple |
|
|
|
|
|
|
|
|
|
|
|
| Measure1 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 7 | 1 |
| Measure2 | 210 | 209 | 208 | 207 | 206 | 205 | 204 | 203 | -7 | -1 |
Banana |
|
|
|
|
|
|
|
|
|
|
|
| Measure1 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 52 | 2 | -4 |
| Measure2 | 150 | 149 | 148 | 147 | 146 | 145 | 144 | 148 | -2 | 4 |
Is there a way to do this?
I'm able to have them in 2 separate tables but the UX is really bad.
Any help is appreciated.
Kind regards,
Jon
@Anonymous , Hybrid display is a challenge
there is a blog by @PaulDBrown :https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
See if that can help.
Also vote for Idea: Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |