Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |