Forum Discussion
Exporting Matrix Table Workarounds ?
The problem is more that the organization is very Excel dependent, and oftentimes they need their own working copy of the document, as opposed to just viewing the content.
My main column that I need is a year-by-year financial statistic; I was considering just making a calculated column for each year.
e.g., "2019 Revenue", "2018 Revenue", and so on and adding it as an additional report page. The main issue here is that if they use the slicers to filter the report, those columns either won't change values (if it's a column) or they will zero out (if they are a measure). Is there any way to conditionally display a column/measure to replicate the output of a matrix visual using this strategy?
Has anyone else in the community come up with similar workaround?
Anonymous Did you ever find a workaround to this? I am in the middle of trying to migrate a small group of users off Tableau and on to Power BI. But they frequently send filtered views of their reports to outside suppliers, etc., from Tableau. Asking them to create something in Power BI, then re-create that same thing as a pivot in Excel is just not going to happen.
Not really. In my case, the Matrix report was a year by year financial report, and I made a calculated field for each year and just used an ordinary table. There are a lot of caveats to this, but it does export correctly.