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.
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
Solved! Go to 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.
Proud to be a Super User!
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/
Proud to be a Super User!
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!
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.
Proud to be a Super User!
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.
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |