Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
My employer is moving from Tableau to Power BI. I'm trying to recreate my Tableau workbooks in BI, and I've run into a visualization that I can't find a way to duplicate in BI. It displays the number of attendees at meetings that took place in a given month and year. This feels like it should be simple, but I'm stumped. Any help would be greatly appreciated.
Solved! Go to Solution.
@Greenterer , Matrix Visual, Year on Row and Month on Column, You need have month column along with sort column in your table
Tableau Vs Power BI- Chapter 7- Matrix: https://youtu.be/jESlfb_D8Us
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Month Year = FORMAT([Date],"mmmm")
Month Year sort = month([DAte])
@Greenterer , Matrix Visual, Year on Row and Month on Column, You need have month column along with sort column in your table
Tableau Vs Power BI- Chapter 7- Matrix: https://youtu.be/jESlfb_D8Us
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Month Year = FORMAT([Date],"mmmm")
Month Year sort = month([DAte])
Thank you. Worked perfectly!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |