Forum Discussion
hemann
1 year agoHelper I
Display all data points in table or matrix
Hi PBI Gurus, I want to display all data points for products by orientation and not have it summarise the data. Below is a sample of the data table. Also below is the desired result with the orientat...
Anonymous
1 year agoNot applicable
Thanks for AllisonKennedy's concern about this issue.
Hi, hemann
I am glad to help you.
First you can open Transform data and Ctrl+click to select the Qrientation column and Value column for pivot column:
Then Ctrl+click select columns 1,2,3,4 and use replace value to change null to 0:
Result:
I have attached the pbix file below, hope this helps!
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.