One visual with month by month and year to date measures?

[aavilap]

Hi all, 

Hope someone can help me with a trick to have this solved, I'm trying to create a table or matrix where I can show both month-by-month and Year to date mesures, the problem comes when I try to show 2 different measures, below is the example of what I am trying to achieve:

In the table columns Jan -May are referring to monthly sales, I have those 5 into one table by putting Months as columns and my Sales measure in Values, however, I have YTD Sales, Prior Year YTD and % Growth as 3 separate measures so when I put the 3 of them in my matrix I get 3 columns under each month instead of the table shown above, I'm not sure if this is achievable but would appreciate any thoughts or input to get there.

Thanks!

Ale

[danextian]

Hi @aavilap,

If I understand correctly, you are trying to show your measures on rows and not on columns. This feature is already available in matrix visual. Check this out https://datasavvy.me/2017/08/10/you-can-now-put-values-on-rows-in-power-bi/

[aavilap]

Hi @danextian thanks for your response, putting measures as rows is not exactly what I'm looking for, because in Rows I have Distributor and Clients (two other columns from my model) the problem is that I do not know how to put a month by month evolution for sales, and also put 3 other measures but those should only be on a cummulative (YTD) basis and not on the month by month evolution.

Any thoughts?

Thanks!

[danextian · Accepted solution]

You can get my solution from this link. https://drive.google.com/open?id=1NqgAwTZ-NgjC-HGOvLFbf205gsEl_Y61

The result is as shown below. You may increase the granularity of the matrix as desired.

[Rajesh1093]

Thanks @danextian your solution worked fine and it solved my problem 🙂 

[aavilap]

Thanks @danextian ! This totally solved my problem!

[danextian]

If you mean to present it in Power BI very similar with how your table looks, I would say it is possible but  will be finnicky. It will involve creating a table that just has the columns you need. I am not aware of an existing visual that can do what you want out of the box. 

[tkramer]

This is awesome! Question.  How would I sort by one of these values?  For example, I want to sort by the "YTD Sales" column, but can not figure out how to do so.  Do you know if this is possible?

[danextian]

you mean sorting a specific column in the matrix?