Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sg1234
Frequent Visitor

Exporting summarized data does not include lines where the measure is the same as the previous line

Reposted here as I think I originally posted it in the wrong section (Report Server).  Sorry!

 

Hi, 

I hope you can help me with my problem please.  I have a matrix that displays a caluclated measure in Power BI.  The measure is calculated usinng a number of variables and is cumulative over a period.  So for example if there is nothing to add on in the second period, the total will be the same as the previous period.  The measure works well and is displayed as expected in a matrix in a Power BI Server report and looks like the below.  The bold rows are totals.  And for example the highlighted blue row has 

0 in Period 1, 

18,000 in Period 2, 

nothing happens in Period 3, so the total is still 18,000 

78,000 in Period 4 and Period 5

and then 38,000 in Period 6

 

sg1234_0-1692304213334.png

 

 

This is all as expected.  The problem is when one of my users wants to export this in as summarized data, neither the zero rows or the duplicate 18,000 row is included in the data (for the blue highlighted row).  You can see from the screenshot below that not all periods are exported.

 

sg1234_1-1692304213227.png

 

 

Is there a away to change this please?  My users like to export the data in table format and so they use the Summarized Data option when exporting.  If they export using Data With Current Layout, it is not in a very user friendly format for them as they like to pivot the data in Excel etc.

 

Many thanks for your help.

 

Sarah

 

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

Hi , @sg1234 

According to your description, you use a measure to get the rolling sum of the value per period and you export it to excel/csv in Power BI Service.

And you find that the same value and 0 do not display in the excel .

I test it in my side , this is my test data:

vyueyunzhmsft_0-1692601029701.png

And i create a measure to test:

vyueyunzhmsft_1-1692602592609.png

And when i export it to excel , the data is all display :

vyueyunzhmsft_2-1692602642751.png

 

What I want to say is that the export of Power Bi Service is the default behavior, and we have no place to modify the export result of this behavior.

And in my test, I exported the corresponding data, and I don't know how you achieve your Measure. If I need me to help you test, you can use your Sample PBix (delete sensitive data).

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 



View solution in original post

1 REPLY 1
v-yueyunzh-msft
Community Support
Community Support

Hi , @sg1234 

According to your description, you use a measure to get the rolling sum of the value per period and you export it to excel/csv in Power BI Service.

And you find that the same value and 0 do not display in the excel .

I test it in my side , this is my test data:

vyueyunzhmsft_0-1692601029701.png

And i create a measure to test:

vyueyunzhmsft_1-1692602592609.png

And when i export it to excel , the data is all display :

vyueyunzhmsft_2-1692602642751.png

 

What I want to say is that the export of Power Bi Service is the default behavior, and we have no place to modify the export result of this behavior.

And in my test, I exported the corresponding data, and I don't know how you achieve your Measure. If I need me to help you test, you can use your Sample PBix (delete sensitive data).

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.