Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello the community, hope you're well.
I'm facing an issue and hope you'll be able to help me.
I have a matrice with a lot of datas and I've noticed that if a ligne have two same rows, Power BI brings them together immediately and sum the numbers.
Do you think that it's possible to tell Power BI do not summarize any row of the matrice ?
Thank you.
Hi, @eric98
As shown in the figure, when you have a unique value like SYR_ Barcode, you can add it to the table. In this way, values like SYR_SYSTEL and SYR_QUANTITA will not be summed.
If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it(visual type, visual setting etc...)?
Community Support Team _ Charlottez
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@eric98 check out this article:
https://datacornering.com/create-group-index-column-by-using-dax/
After adding index column in your table you can use it as additional field in matrix to unsummarize rows.
I didn't really understand the article.
I'm sorry i'm a beginner in Power BI
@eric98 You should have some additional unique value for matrix row. You can add calculated column with some index, for example.
I didn't really understand what you meant. Can you give me an example please ?
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |