I see big value in creating a visual that can display the results of a DAX query. One way this could be deployed is a follows.
* Add the new visual to the report canvas
* Write a DAX query that returns a table (of course) and add this to the visual
* The visual would respect any cross filtering coming from the report just like any other visual.
This would give report writers very granular control to display records without having to use a table visual and a measure that triggers the display of the correct records.1,394 votes
At the moment we don’t have any plans to implement this. It sounds like it’s mostly useful for learning/training? If there are other ‘production’ scenarios that you think it’d be useful, where a regular table/matrix wouldn’t work, please let us know in the comments!
I have volumes of information to share with my teams that is best presented in tables and matrices. It would be a huge improvement if they were able to export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.
This would be especially helpful for ongoing forecasting activities.3,810 votes
Thanks for your feedback on this issue – while we’d like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn’t a solution everyone can take advantage of currently.
- Don't see your idea?