Forum Discussion

Mahendra_k's avatar
Mahendra_k
Icon for Helper I rankHelper I
10 months ago
Solved

How to create a side-by-side dynamic table layout (two category groups with same unit columns)

Hi everyone, I want to create a dynamic visual in Power BI that shows two sets of categories side-by-side with the same unit columns. The layout I want to achieve (visually) is: Left block: Ca...
Need Help
Tips and Tricks
  • v-ssriganesh's avatar
    v-ssriganesh
    10 months ago

    Hello Mahendra_k,
    Thank you for posting your query in the Microsoft Fabric Community Forum.

    I’ve reproduced your exact requirement in Power BI Desktop using your sample layout and data logic. The side-by-side dynamic table with identical Unit1–Unit3 columns is fully working in a single visual and responds perfectly to slicers (Region, Year). For your reference, I’ve attached the .pbix file.

    If I misunderstand your needs or you still have problems on it, please feel free to let us know. 
    Thanks,
    Ganesh Singamshetty.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
10 months ago

Hello Mahendra_k,
Thank you for posting your query in the Microsoft Fabric Community Forum.

I’ve reproduced your exact requirement in Power BI Desktop using your sample layout and data logic. The side-by-side dynamic table with identical Unit1–Unit3 columns is fully working in a single visual and responds perfectly to slicers (Region, Year). For your reference, I’ve attached the .pbix file.

If I misunderstand your needs or you still have problems on it, please feel free to let us know. 
Thanks,
Ganesh Singamshetty.