Forum Discussion

HamzaLam's avatar
HamzaLam
Frequent Visitor
1 year ago
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 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 

 

 

  • 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).

7 Replies

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

    • HamzaLam's avatar
      HamzaLam
      Frequent Visitor

      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's avatar
        lbendlin
        Super User

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

  • 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).