Forum Discussion
Helper IIIShow a single matrix value on rows / formatting matrix
Hi experts,
I have a matrix with a bunch of related financial metrics for an engineering firm but I have a some metrics which need to be filtered differently and I was hoping I could show them in that same matrix but it doesn't look like that is possible. So instead I was hoping to put them into their own Matrices and align them with the master so it at least flows even if I end up with some gaps between them. I have a hit a couple of snags with this approach:
Snag 1:
I can't seem to find a way to get a single value into a matrix and show it on rows. If I leave the single value I get this look: with no header label:
But if I add any other value to it I get the look I want but have an unwanted row (I just threw a rowcount in to demonstrate):
So is there a way to show a single value in rows on a matrix or some sort of workaround?
Snag 2:
The second snag is being able to shrink the boundaries of the matrix so that it is small enough to appear as just a single row - no scroll bars or padding, etc. This way I could move it right up below my main matrix so it at least appears to be related to it.
I'm open to any other suggestions to solve either problem!
Thanks in advance,
Kevin Coles
4 Replies
- AllisonKennedy
Community Champion
Could you use a card visual instead of matrix?
KevinColesHi AllisonKennedy ,
I had considered this because I have a handful of metrics that require unique filtering so they can't really fit in the matrix I have with the majority of the metrics. The only problem is that I have a multiple select Accounting Period slicer. Users want to be able to see one or more months of data at a time.
If I can convince them to fix it at 1 month at a time I may build a small section of tiled Card visuals, but it doesn't look like they will go for that.
Thanks,
Kevin- AllisonKennedyWhat is the difference in filtering? Could you build that into a DAX calculation so they can all still be in the same matrix?
