Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
When I created a matrix table in my dashboard, I want to exclude specific rows where there are duplicate invoice line number and null PO Number. In the column "exclude", it displays the tag which I want to be excluded from my matrix table.
I tried to create the "exclude" column tag in PowerBI but could not make it work properly if the columns are displayed in matrix table.
I'm not sure if this will help: In the matrix table, it's showing duplicate but in the backend there are more than 2 count.
@summer18 , Looking at sample data you can take PO Number as value in Matrix as Min or Max. Or in the table as Min/max or first/last in table
or use formula for PO firstnonblank(Table[Po],blank())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |