Forum Discussion
Summarize table based on column values
Hi I have a spreadsheet which is set up as below. Its a list of notifications and the individual tasks associated with the notification and the individual completion dates. The tasks may be the same ...
Hellow fingalbrad ,
Have you tried using the matrix visual. You can drag Notification and Priority columns to Rows, Tasks to Columns and Completed date to Value. If you want a layout very similar to yours, may disable the stepped layout and the subtotals. Once plotted, your data should looke like below:
More on the matrix visual: Create matrix visualizations in Power BI
Hi
I want to be able to do some analysis tho and compare the dates between the tasks. I dont think I can do this with a visual??