PowerBi two different table visualisation in one table

[HamzaLam]

Hi all 

I have two different tables visualisations that has same information, one is from actual month , the second one (wich is below the first one) has same info but from last month, my only problem with this is the first one get shifted from the second and vice versa (see the picture below), is there any way to fix this so they'll stay perfectly aligned ? 

Many thanks 

[audreygerred · Accepted solution]

Rather than having two visuals stacked on top of one another, I suggest creating two measures. One for current month and one for previous month. Then have your measures display in rows rather than columns (you can do this in formatting and in the values section).

[lbendlin]

They will never align.  Why not have a single table visual with both months?

[HamzaLam]

Thanks for the reply, if i do it in one table visuals for both month it wont be one below the other but one next to the other no ?

[lbendlin]

no, they will be below each other, one row per month.

[HamzaLam]

I added the month for the other table and it's next to the first month not below, am'i missing somthing or not doing it right ?

[PBIViz_2024]

Hi,

I also agree with above two suggestions.The best way to create one table with both the months instead of two tables.

There are several ways you can achieve this.

• First use Matrix visual instead of table visual which you have currently used.
• Your columns seems to be measures you have created.so that if you have calender table in you model or Date column.You can use year and month part as rows in the matrix as shown below.

• You can even use two calculation groups for current Month & previous month if all the columns are measures.

If you need more assistance,If you can share a pbix file with dummy data i will be happy to help.

Regards,

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...