In a previous post about how to use Tableau Exclude LOD in Power BI, we briefly mentioned ALLSELECTED. However, ALLSELECTED is a more powerful and complex function than we covered at that time. In this article, we’ll delve deeper into not only ALLSELECTED but also its counterpart, ALL, to fully understand their capabilities and applications in Power BI.
Continue reading
When working with data in Power BI, summarizing and grouping data is essential for gaining insights and preparing reports. These operations allow you to aggregate values, perform calculations, and create custom tables or visuals based on specific grouping conditions.
Continue reading
Unit progress bar charts are a fantastic way to represent progress toward a goal, breaking the visualization into smaller units to highlight individual contributions. These charts are both visually appealing and effective for storytelling. In this post, we’ll guide you through the process of creating a unit progress bar chart in Tableau using the Superstore dataset.
Continue reading
SQL window functions are one of the most powerful tools for performing calculations across a defined range of rows while maintaining access to individual row-level details. Unlike aggregate functions that collapse rows into a single value, window functions allow you to perform calculations over a subset of rows (a window) while preserving the original row structure.
Continue reading
Diverging bar charts, also known as “bikini charts,” are a fantastic way to compare two opposing metrics or categories. Unlike traditional side-by-side bar charts, diverging bar charts place the bars opposite each other with a shared Y-axis in the middle, making comparisons intuitive and visually striking.
Continue reading
Dumbbell charts are a fantastic visualization tool for comparing two data points across categories while emphasizing the difference between them. Often used to show progress or change over time, these charts highlight how values diverge or converge for each category. In this blog post, we’ll walk you through how to create a dumbbell chart in Tableau using the Superstore dataset.
Continue reading
When working with large datasets in Power BI, efficiency is key. One of the most powerful optimization techniques is query folding, a process that enables Power BI to push transformations back to the data source instead of handling them locally. But what exactly is query folding, and why is it important?
Continue reading
In the world of data visualization and reporting, keeping track of the last time your data was refreshed is crucial for ensuring accuracy and reliability. Whether you’re using Power BI or Tableau, adding a refresh timestamp provides transparency and confidence to your audience.
Continue reading
Dynamic titles in Power BI are a great way to make your reports interactive and user-friendly by displaying context-aware information based on the selected data. In this blog, we’ll walk you through the steps to create dynamic titles using the Sample Superstore dataset.
Continue reading
In data visualization, the right design can make your insights not just clearer but also more engaging. Rounded bar charts and bar-in-bar charts are two excellent options for adding polish and depth to your dashboards. These chart types bring a modern touch to traditional visuals while enhancing storytelling and usability. In this blog post, we’ll use Tableau’s Superstore dataset to create these charts and discuss their applications.
Continue reading