How do I create a summary for the following table?

[HamidBee]

I plan on creating a summary table of this:

Detailed Table

 

Into this..

Summary Table

The idea is that I will be able to drill up from the detailed table to see the summary table. Does anyone know how to create such a thing?

Thank you

 

[Anonymous]

Hi @HamidBee ,

Please try to use bookmarks.

Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order, and so on. When others view your report, they can get back to that exact state by selecting your saved bookmark.

When you create a bookmark, the following elements are saved with the bookmark:

• The current page
• Filters
• Slicers, including slicer type (for example, dropdown or list) and slicer state
• Visual selection state (such as cross-highlight filters)
• Sort order
• Drill location
• Visibility of an object (by using the Selection pane)
• The focus or Spotlight mode of any visible object

Please refer to the following document for more information.

https://docs.microsoft.com/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop

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

Best Regards

Community Support Team _ Polly

[parry2k]

@HamidBee why do you want a new table when you can visualize the same with the matrix visual. Put the date on rows, Letter on the column, and count on values and that will do it.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡