Here is answer for Christmas Challenge 2025 days 9-16
Day 9 – One Visual, Multiple different measures
s
When scripting this to TMDL it looks like:
And then you can add a slicer of the calculation group and that changes how the visual behaves.
Day 10 – Visuals that change dimensions on the fly
Day 10 was about field parameters.
Then we can create visual that uses new “valitse dimensio” field and slicer from that field also. And it just works.
Day 11 – Making months work
This was easy. It is order by column.
Day 12 – Custom Calendars
s
Day 13 – Relationships with DAX
Day 13 was about modifying Sales measure. You achieve goal for example like this:
Day 14 – Sum against Total sum
Day 14 was about modifying total sales measure. Here an example:
Day 15 – Formatting measures
Day 15 was about formatting measures. It can be achieved like:
Day 16 – Sales vs total sales of selected time
Day 16 was about sales vs total sales. It was achieved with measure like:
