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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JiapengSun
New Member

The summarization feature is not available in specific report

Hi,

 

I have a 3 dimention data like "Product"-"Year"-"Sales", I use to have a matrix data view for it, where "Product" as row, "Year" as coloum and "Sales" as value, sometimes there are mutiple records for sales so I use the "max" or "first" option to summarize it.

 

Recent I met a strange problem, if I remove "Sales" from Value, then try to drag it back like before, it's not working, I was simplely not able to dray "Sales" into value, I also tried drag it to coloum or row then use the move option to move it to value, then the Power BI start to no response at all and I have to close and reopen it. I tried reinstall Power BI and restart computer, nothing works.

 

Then I realize it was  the problem at summarization because if I create a card for "Sales", normally it will be summarized and shown, but now I also not able to drag it into the value.

 

I also tried some other data, all same problems, seems like the summarizarion feature is dead in my report.

 

I created a new report and use the exactly same data to create a matrix like before, works fine, so the problem only happends to my old report 😞

 

I did a lot of research and no clue get, please help me 😞

2 REPLIES 2
amitchandak
Super User
Super User

@JiapengSun , In a matrix when you drag a column on Row/Column you will not get summarize option. When dearg to values you will get. Now if you have created a measure it will not show summarize option. Or if you have set up it as not summarized in Column tools, it might not get dragged to values.

Hi!

 

Thanks for the reply, it's not a measure and I tried set it to some other options than "not summarized", but nothing works..

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.