Forum Discussion
Solved
Compare data from 2 dates side by side?
In the Power BI report I am currently working with I have unpivoted data with columns Attribute, Date and Value. Currently I have a report page with a column graph having a date slicer allowing viewi...
The solution we arrived at in the end was to create 3 new columns as follows:
Year = YEAR('Unpivoted Data'[Date]) Week = WEEKNUM('Unpivoted Data'[Date],2) Weekday = SWITCH(WEEKDAY('Unpivoted Data'[Date],2),1,"1. Monday",2,"2. Tuesday",3,"3. Wednesday",4,"4. Thursday",5,"5. Friday",6,"6. Saturday",7,"7. Sunday")We were then able to put the Year column into the chart's legend and a multi-select slicer and the Week and Weekday columns as single-select slicers.
The solution we arrived at in the end was to create 3 new columns as follows:
Year = YEAR('Unpivoted Data'[Date])
Week = WEEKNUM('Unpivoted Data'[Date],2)
Weekday = SWITCH(WEEKDAY('Unpivoted Data'[Date],2),1,"1. Monday",2,"2. Tuesday",3,"3. Wednesday",4,"4. Thursday",5,"5. Friday",6,"6. Saturday",7,"7. Sunday")We were then able to put the Year column into the chart's legend and a multi-select slicer and the Week and Weekday columns as single-select slicers.