Forum Discussion

fahadkhan's avatar
fahadkhan
Frequent Visitor
4 years ago
Solved

Showing pivoted / transposed measures in Tabular Visual

Hello Everyone, 

 

I have been wraping my head around for quite some time now, and can't seem to fine a solution. so here is a sinario: 

 

What I have? 

I have 3 measures and a Date Table

  • Dates Table
  • Targets (sum of all target values)
  • Actuals (sum of all Actual values)
  • Variance (difference between actual - Targets)

Table I have

 

What I am Trying to Achive?

is showing the visual above in a transposed/pivoted form in report view. like example below. 

 

 

Please help I have been trying really hard but havn't found a workable solution. 

Thanks! 

  • Hi, fahadkhan ;
    You could create a matrix.and  the original such as :

    we could change the setting.

    When is Quarter.

    The month is:

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support

    Hi, fahadkhan ;
    You could create a matrix.and  the original such as :

    we could change the setting.

    When is Quarter.

    The month is:

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.