Receive updates from SQLBI for free, starting right now.
We can deliver them by email, via your phone or you can read them from a personalised news page on follow.it.
This way you won't miss any new article from SQLBI. Unsubscribe at any time.
Site title: Error 404 (Not Found)!!1
Is this your feed? Claim it!
How to visualize and analyze ticket sales and seat occupancy in a large venue, The Sphere in Las Vegas, using a custom graphical layout created with Synoptic Panel in Power BI.
The report combines both numerical tables and interactive SVG maps, enabling users to visualize revenues, seating categories, and occupancy patterns by directly viewing the venue’s physical layo...
How to find 𝗲𝘃𝗲𝗿𝗴𝗿𝗲𝗲𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀 in DAX. Top 10 products are a classic. Reporting which products are in the top 10 for several years is more challenging.
This article outlines the process of creating a measure to identify the top 10 products by sales each year.
We have written and updated a few pieces in the past about how to find the top products, such as Filtering the top pro...
This video shows a real use case of the Synoptic Panel visual in Power BI applied to dental analytics: users can understand clinic-wide patterns by turning dental records into an interactive visual of the mouth.
Complete Case Study
https://okviz.com/usecase/tooth-replacement-synoptic-panel/
Try Synoptic Panel
https://okviz.com/synoptic-panel/
When to use VALUES in the table grouped by SUMMARIZE, and why SUMMARIZECOLUMNS does not have that option.
