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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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