Forum Discussion

hallie1093's avatar
hallie1093
Frequent Visitor
6 years ago
Solved

How to Show Different Date Aggregations in a Matrix Visual (Single Month and Annual)

 

 

Hi All,

 

I am trying to create a matrix visualization in Power BI that displays values at two different date levels 1) the latest month (this could be selected in a filter or coded into a DAX statement) and 2) the annual values for the same field (see below for example).

 

 
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi hallie1093, 

    Becuase the last month in Matrix need to be column, so I think it is hard to get your expected output in one visual. I thinkk you could achieve this in two Matrix. Or get the result like below

     You could refer to my sample for more details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi hallie1093, 

    Becuase the last month in Matrix need to be column, so I think it is hard to get your expected output in one visual. I thinkk you could achieve this in two Matrix. Or get the result like below

     You could refer to my sample for more details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.