cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Include change from year end in measure's matrix line

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

 

 

1 REPLY 1
Super User IV
Super User IV

@JonArgandona , 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/1...

 

See if that can help.

 

Also vote for Idea: Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors