Export Underlying data issue in matrix visual

[hemanth52130]

Hi Team,

I have some issues while working with underlying option in export data in matrix visual.

I am filtering some records using hierarchy slicer and exporting the data using underlying data option in matrix visual. Here i am getting all the records irreespective of slicer selection. point to note I am using caculated measure in the matrix visual. Exporting data for other visuals are working fine.

Ex: when i filter and export the data using underlying data option i need to get only 50 records but i am seeing 1000+ records.

Please help in providing solution.

Thanks.

[v-lili6-msft]

hi, @hemanth52130 

I have test on my side, it works well.

For example:

for the two excel result, one is export data from matrix visual and another is exported data from bar chart visual.

They are all the same.

Please check if there is something wrong in other.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-underlyi...

If you still have the problem, please share your sample pbix file and your expected output for us have a test.

Best Regards,

Lin