I made a mock up of an excel table that I want to be populating as the years go on, but it doesn't trasnslate well in Power BI because of merged cells.
You can see what I made in Excel, and how it looks in Power BI.Excel TablePower BI Translation
Does anybody have any suggestions for a better way to format this is excel so that it will "translate" properly? Thanks in advance!
Go to Solution.
I would suggest something like this (sorry, my image embed isn't working):Excel: https://imgur.com/wk9lCAm
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.