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 DA...
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.

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.