Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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).
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |