After a 2 day crush my brain trying to rebuild rome in Report Builder because I could not figure this out in PBI... I find this! THANK YOU! Huge time saver my friend!
Hi @Jason Davidson, Thank you very much help ful. When we change the option, we are unable to add a sub row. Like I want keep backlog row header and add a add a department as a sub row.
So cool, exactly what my client needs. However...is there a way to sort the data by the measure value? For example if you group the measure rows by (say) department, how do you then sort the matrix by department on a given measure (e.g. sales)? It seems to default to the department name as the sort value.
Does anyone know if there is a way to show the values as the first row? For example if I wanted to compare Maintenance and Accounting department backlog like this example I would want to see Backlog then the list of departments for comparison.
Thanks mate, 2 mins of video were more worthy than hours of research.
u are a godsend. 3 hours of searchign for this mate 3 HOURS. THANK U SO MUCH
After a 2 day crush my brain trying to rebuild rome in Report Builder because I could not figure this out in PBI... I find this! THANK YOU! Huge time saver my friend!
This is EXACTLY what I have been looking for!!!
It's such a simple little feature is it!
I’ve been trying to figure this out for the last couple of hours! Thank you so much 🙏🏾
Exactly what I have been looking for. Thankyou.
Excellent tip! I can't believe I never noticed that before.
Thanks, it a wee gem isn't it!
I have been looking for this trick for 2 week Thanks Alot
Great stuff. It's a wee hidden gem isn't it!
woahhhh i search this for like ages, don t know it was this simple LOL damn gotta tell boss asap thx sir😂😂😂
Thank you for this! I wasted a few hours trying to figure this out.
Thanks for this solution! Could not find any way to do this... till now!
This is VERY VERY helpful, thank you so much for the GREAT sharing 👍👍👍
Muah! Man you made my day! I was struggling with the for a while and now thanks to you, hey presto!!
So glad I could help out. 😁
Very useful! Thanks so much for this fantastic trick!
I know, it so simple. I don't know why I didn't notice this before now :-)
you save me, Thank'ssssssssssss
Thank you very much
Always forget where this option is, thanks for posting. Was considering re-structuring my dataset to meet this requirement 🤣
Love this video Boss
Thank you so much!! It was quick and important trick
Awesome, thank you!
Thanks 😊
u r amazing ❣❣
I'm not sure about that, but thanks 😁
Brilliant!
This is a great tip, thanks! It's a pity the format is not preserved when exporting to Excel...
Hi @Jason Davidson, Thank you very much help ful.
When we change the option, we are unable to add a sub row. Like I want keep backlog row header and add a add a department as a sub row.
Thank you
Thanks a lot Sir.. u save my day
Thanks for the tip! Do you know how can we sort the measures by their values?
Awesome! Thx
So helpful, thank you!
but bro what id i want to show total top 😢my boss want date column but also total
THANK YOU SO MUCH!!!
Thank you so much. Can we add the row number ?
What if i want the date also in the rows but in a next column not along with the department
So cool, exactly what my client needs. However...is there a way to sort the data by the measure value? For example if you group the measure rows by (say) department, how do you then sort the matrix by department on a given measure (e.g. sales)? It seems to default to the department name as the sort value.
Hi finally, I'm not sure, I'll need to check it out. It would be good if it was possible
Why don't the names of the values show up for me?
Does anyone know if there is a way to show the values as the first row? For example if I wanted to compare Maintenance and Accounting department backlog like this example I would want to see Backlog then the list of departments for comparison.
awesome !