Forum Discussion
PowerBi two different table visualisation in one table
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).
no, they will be below each other, one row per month.
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,
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-Forum/ba-p/963216
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/1447523
