cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jessie_
Regular Visitor

difference between "Use as category" and "Summarized"

Hello everyone,

 

I am a beginner in Power BI. I don't quite understand the difference between "Use as category" and "Summarized" when using Drillthrough. This may be a very simple question, but I can't get it out. Can anyone help me? 😁 

 

Capture.PNG

 

 

Best Regards,

Jessie

1 REPLY 1
amitchandak
Super User
Super User

@Jessie_ , Based on what I can get Summarized means data will aggregate like, sum/min/max. Category means it will not aggregate and it will be group by or filter.

 

refer to this in doc

"

When you add a measure or summarized numeric column, you can drill through to the page when the field is used in the Value area of a visual.

That's all there is to using drillthrough in your reports. It's a great way to get an expanded view of the entity information that you selected for your drillthrough filter.

"

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough#add-a-measure-to-drill...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors