cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aquraini Frequent Visitor
Frequent Visitor

Export Underlying Data to XLS

Hi,

 

I am trying to export the underlying data from one of the reports but I get the export underlying option dimmed and can't select it.

I got the following hint "You must first add an aggregator to your chart"

 

Can you help in this regard?

 

Thank you in Advanced,

Ayman

  

aaa.JPG

6 REPLIES 6

Re: Export Underlying Data to XLS

Where did you encounter the issue?

aquraini Frequent Visitor
Frequent Visitor

Re: Export Underlying Data to XLS

both at report and focus mode

Re: Export Underlying Data to XLS

As the message says, you must add an aggregator to your chart first, please refer to this article.

arielfilipa Regular Visitor
Regular Visitor

Re: Export Underlying Data to XLS

Hi,

 

I'm using a calculated measure so unfortunately the article that you mentioned doesn't help :-(

 

Is there another way to export underlying data ?

SonaliG_LeX Regular Visitor
Regular Visitor

Re: Export Underlying Data to XLS

arielfilipa Regular Visitor
Regular Visitor

Re: Export Underlying Data to XLS

Thanks but unfortunately it doesn't help :-(

 

I will try to get the same values using a column or aggregate field...

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 523 members 4,300 guests
Please welcome our newest community members: