Forum Discussion

hemann's avatar
hemann
Helper I
1 year ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

hemann's avatar
hemann
Helper I
1 year ago

I tried this my real data is too large for this to work. 

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    1 year ago

    hemann just to be clear, you do not need to pivot your data - this can be done in the matrix visual. As Ashish_Mathur  and I have said, all you need to do is add an index. Then you'll need to mark the product as the row identifier. Please let us know if you're able to solve it.