Forum Discussion
Adjust matrix table - hide unnecessary column
Dear All, I have built a matrix table with data for actual and budgeted values per type. I also added a % comparison (how much ACT differs from BGT), but it is (obviously) showed twice - is there...
This is exactly what I need! ๐ Looks perfect!
I tried to copy your solution to my PBI and unfortunately, I don't see neither all Cost Types nor columns "BGT"/"ACT" in the matrix.
Do you know what might be causing the issue? I do have some rows empty in my table - I mean that they have no value.
Hi, Anonymous
Try select the row and right-click๏ผchoose Show items with no data.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the suggestion, but still no luck ๐
I focused on Revenue and I can see the total amounts as well as the measure calculated correctly, but for some reason the columns ACT and BGT are empty: