Forum Discussion
Solved
Urgent Support for matrix table
Dear all .. not very good with Power Bi and need your support to re create the above table in matrix table : Bellow is may data : Year_Month Product Customer Real PCS Bdg PCS ...
Hi alexbalazsalex,
You can do the grouping base on the column in two ways:
1. Advance Query Editor
- Add conditional column and place the following code:
2. In front end
- Select the column you and and right click or ... and choose New group
- On the next window select the value to group and choose the names
- Then add this to the columns in the matrix.
In attach is the PBIX file for download (this is a WeTransfer and it's only available 7 days)
Any further questions please tell me.
And sorry for the delay.
Regards,
MFelix
Hi alexbalazsalex,
Don't understand your question. The unpivot of columns will make a single row for each attribute (is what you refer as multipying??) because as said before you can't have the data with a title and subtitle within measures.
In terms of performance by the PBI model you should not have big issues since everything is done when refreshing the model, again this is just a workaround to give the title/ subtitle since you can't use measures in the hierarchy.
Regards,
MFelix
Don't understand your question. The unpivot of columns will make a single row for each attribute (is what you refer as multipying??) because as said before you can't have the data with a title and subtitle within measures.
In terms of performance by the PBI model you should not have big issues since everything is done when refreshing the model, again this is just a workaround to give the title/ subtitle since you can't use measures in the hierarchy.
Regards,
MFelix
Hi MFelix,
thanks for your patiente and suport ..
And this unpivoting can be done stragit in Power bi ? or have to be done before as i ve seen tha tyou have "Type" column in you attached fiel already ..
Thanks Alex
Hi alexbalazsalex,
This unpivoting is done in the query editor.
If you go to the PBIX file I shared you can check how it works.
Any questions please tell me
MFelix