Forum Discussion
NhatAnhDo
9 years agoNew Member
Data export does not match matrix data after filtering
Hi,
I have a maxtrix set up like this.
I then i create a filter for value as "only less than 13" then only Pos 1 - 7 will appear (which is what i want)
When i export the data, it only excluded the value in BOLD.
Is there any other filter method that will effect the export table?
| Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Total | |
| POS 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| POS 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| POS 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| POS 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| POS 5 | 0 | 5 | 0 | 5 | 0 | 0 | 10 |
| POS 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| POS 7 | 3 | 1 | 2 | 2 | 2 | 2 | 12 |
| POS 8 | 8 | 8 | 8 | 8 | 8 | 8 | 36 |
| POS 9 | 1 | 2 | 34 | 1 | 24 | 8 | 69 |
1 Reply
- Eric_ZhangMicrosoft Employee
When saying exporting, do you mean export from Power BI desktop or Service?
Could you please upload the pbix for testing purpose, you can upload it to a network drive such as Onenote and share the link.