Create BANS you can interact with.

Create BANS you can interact with.

The process to create this is quite elaborate, rather than bore you with the obvious. I’m going to document the ambiguous parts of this build, the rest you should be able to decipher when you look at the sheets in the workbook. So, download the workbook from my...
Level up your stacked bar charts with Sets!

Level up your stacked bar charts with Sets!

If you are using a stacked bar chart on your dashboard and your stakeholders are looking to compare a few variables over time, as a minimum requirement you must have dynamic sort built into the visual. What I am going to show you today is the next level of interaction...
How to compare Half-Yearly Sales?

How to compare Half-Yearly Sales?

I had this request from a client to be able to see (let’s say sales) Sales by half-yearly. what made this one trickier, was that the company’s FY starts in July, so the first half of the Fiscal Year 2023 is from July 2022 – December 2022. Which translates to...