Dynamic matrix rows

[jja]

Hi

I have a matrix table with total of 3 levels. (Rows)

Now if i export dsata it exports me all the underlying data but i want to export by matrix levels.

Is there a way i could select which level to export or which level to show in matrix?

Maybe there is a way to create a measure and a slicer and select how many levels matrix shows?

Ofcourse i could create 3 different matrices with 1 level only but that many tables would mazke a mess in my report.

[v-juanli-msft]

Hi @jja 

Exporting data will export data used in the matrix.

There are two types: summarized and underlying.

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

Your requirement may not be achieved currently.

You may post an idea in Power BI Idea forum.

Best Regards

Maggie