HI Team ,
I need to create table or matrix visual data and requiremtn as follows please suggeset best waty to acheive this.
I have data for each city and date wise sales( Every month data will appepnd to same sheet , in the data which i have given i have considered current month is Feb[It supporsed to be till July as i dont wan to add data i dint add]
Data
Requried output ( If i have data till curent month ex : July , after 2019 columns should be thre from jan to July then 2020 and yoy diff
@BalaVenuGopal , Hybrid tables are not supported yet. I logged an idea for that -https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc . vote for it
The work around is to create columns and display
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
