Forum Discussion
Post PartisanAdding another dimension to matrix table with values as row headers
Super User
1. A sorting column enables you to display the measures in the desired order. In your example, "Total Autobooked Invoices %" is first, so this row would have a 1 in the sort column. In the data view, you can sort DimMeasure[Measure Name] by DimMeasure[Sort Order].
2. Yes, this is the table[column] that contains your measure names.
Post PartisanHey DataInsights
Thank you very much. It's almost exactly what I need!
The formatting is now indeed the remaining thing that needs to be fixed. Some measures are in % or in #, and the specific number of decimals. Can you help me further on this with calculation groups to make specific formatting possible?
Appreciated!!
- DataInsights
Excellent! Here are some articles on calculation groups. You'll need to install Tabular Editor (free tool) to create calculation groups.
https://www.sqlbi.com/articles/introducing-calculation-groups/
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/