Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Here is a portion of a report with a Matrix and a Table. This reports out apprentice training and hours. My business owner wants the report to look as it does here and maybe it is my lack of understanding of matrices, but when I put in "worked hours" into the matrix, the formatting of the columns changes and is not correct. Everything else like slicers for dates (the first column is the day of the month to display even if there is no data), and the actual data and Totals. Is there a way to "sync" or "group" the two visuals so when on is scrolled through the other will automatically do the same?
Thanks for the information. I welcome links to any articles that might show this or show me a better way to do this visualization.
Brad
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
| User | Count |
|---|---|
| 48 | |
| 39 | |
| 29 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 65 | |
| 57 | |
| 40 | |
| 21 | |
| 20 |