I am trying to create a detailed revenue report but struggling to get it right with a matrix table. Attached is the PBI file, hoping someone could help with:
- Matrix table - Anyway to sort the table into my format without having to have the row index?
- Matrix: Summary column: How do I show the total for each summary column?
- Matrix: Level 1 - How to sort so that is goes “Transient”, then "Group; then “Contracted”?
- Changing the week end date to Sunday (currently Saturday);
- Create a daily bar graph (Monday to Sunday) with selected week, last week and same week last year (linked to data table and changed through selection of matrix line)
- Add column in matrix table for Last week, Week before last week, Month to date, Year to date
StuartRevenue Report_DNA.pbix (589.1 KB)