Forum Discussion
Solved
PowerBi two different table visualisation in one table
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 probl...
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).
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 ?
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,