Forum Discussion
Pivot without aggregation
I'm attempting to recreate an existing Qlik dashboard in Power Bi. The dataset is a 24 month dataset and laid out in the table as shown here: The desired format is to display the informatio...
First impressions are that the matrix would work for this (without doing any data transform). What problem are you having with it?
The problem is I need 7 of the fields displayed in a tabular format - not collapsed/hidden - for information purposes for the metric. And I need the Rates displayed accross the remaining columns by YRMO.
Desired Format:
Matrix format:
I did try turning off the stepped layout as you suggested, but it still didn't create the visual I needed.
