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

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

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!.

Top Solution Authors
Top Kudoed Authors