Hi,
I’m trying to get the measures before the row headers/dimensions.
The first two screenshots are from Excel, where you can simply drag the values in front of the row header/dimension
I just don’t know how to get them ‘moved’ in PBI. As the vis-fields’ are kind of ‘fixed’ in what to drag where, I can’t really move any measures/values into the rows.
I’d like the measure names in front of the dimension, so it’s not repeating that often.
@Kathi AFAIK That’s not possible, Measures are for aggregating values and Columns are for slicing the data. Excel’s pivot table is slightly different, even if aggregated everything is still columns.
if you are going to show the values on rows (which is the setting you have chosen), that’s the only way the info is going to display. If you un-check values to rows, then you get this more traditional layout:
The only way to NOT have the value names show up, is to only have a single value in the table:
