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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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