We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Hi everyone. I have the following problem with a matrix in Power BI: The original database is as shown in Image 1, applying "unpivot columns" I have reached image 2. The goal I want to achieve is that in the columns appears months, in the rows categories (Fcst and Inventory), but for Fcst calculates the sum per month and for Inventory calculates the average per month (image 3). By placing the values in the "Fields" section it only allows me to place either sum or average (image 4). The objective is to get a matrix that shows the calculations of image 5 in the same matrix. I hope you can guide me ...
Solved! Go to Solution.
Define these calculations as separate explicit measures and use the "Show on rows" feature rather than use Atributo for the row headers.
If you pivot your data so that there are separate columns for separate metrics,
then you can still use implicit measures and choose your summarization.
Note: This still uses the "Values on rows".
Thanks AlexisOlson. That was the solution to my problem
Define these calculations as separate explicit measures and use the "Show on rows" feature rather than use Atributo for the row headers.
If you pivot your data so that there are separate columns for separate metrics,
then you can still use implicit measures and choose your summarization.
Note: This still uses the "Values on rows".
User | Count |
---|---|
13 | |
12 | |
7 | |
7 | |
6 |
User | Count |
---|---|
26 | |
20 | |
13 | |
11 | |
5 |