In this video, we are going to explore making dynamic axes using DAX measures. This method will allow you to manage complex as well as easy cases.
We will use UNION, SELECTEDCOLUMNS, DISTINCT, SWITCH, SELECTEDVALUE, PREVIOUSQUARTER, PREVIOUSYEAR and some other DAX functions.
0:00 Introduction
3:38 Combine different columns into one in power BI
10:05 Measure for dynamic axis
16:06 Percentage change over previous period in power BI
21:57 Visual Formatting
23:50 Chiclet Slicer
Ultimate guide to calendar in Power BI:
https://www.youtube.com/watch?v=Oq5WOmo94_Q
SWITCH and SELECTEDVALUE functions:
https://www.youtube.com/watch?v=tljRYGz15PA
