The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
8 | |
7 |