Showing results for 
Search instead for 
Did you mean: 
Not applicable

Additional Column to return text in MATRIX visual

Dear all,


Am using Matrix Visual as shown below to return value for each KPI per month.


I want to add an additional column that returns a text value, unfortunatly whenever i add it it doesnt show up it only shows the months. 


This is my current system visual




This is my desired visual



I really need help 🙂 


thank you.

Super User II
Super User II

This might be solvable with a measure that returns different values depending on whether you're in the individual month or the total column. You could probably also rename the total column to match your requirement. I'd suggest posting this question in the DAX forum, as there's a lot more people that frequent there and they'll be more equipped to help with this one than the Develper forum.

Good luck!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Not applicable

i really appreciat your reply and i will post it in DAX now. thank you

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.