Forum Discussion
How to show multiple line items for same row in matrix visual
Hi Anonymous ,
Being your values calculated as measures you don't have the option don't summarize, what you can do to work around that can be create a new column with the [Rows] and [TS] values togethers then use that as your first value on the rows, drill down to the latest level, turn off word wrap and hide that column check the image below:
It's a poor workaround but can be an option, based no the low level of information are showing.
Regards,
MFelix
Super UserOn the values columns choose the don't summarize optio that will return all the values for the selected columns, then based on the filter the information will have several results.
Regards,
MFelix
Hey MFelix ,
I don't see any such option as don't summarise in the values. Basically these columns are measures created and called in as values.
Can you please elaborate a bit more as of where can I find the option
Regards,
- MFelix
Hi Anonymous ,
Being your values calculated as measures you don't have the option don't summarize, what you can do to work around that can be create a new column with the [Rows] and [TS] values togethers then use that as your first value on the rows, drill down to the latest level, turn off word wrap and hide that column check the image below:
It's a poor workaround but can be an option, based no the low level of information are showing.
Regards,
MFelix
- MFelix
Hi Anonymous ,
Forgot to mention that if you will present as a table visual you can also turn off the visual headers so that people don't have the option of making the drill up drill down.
Regards,
MFelix