Hello, I wonder if anyone could advise on how best to start transforming this data for analysis/presentation in a pivot or matrix table:
I am struggling with the category/value columns. Do I need to unpivot the category column (I did try this but it didn't seem to help)?
Solved! Go to Solution.
@adavid999 , if there are not too many values then you should unpivot. What is the problem you are getting.
If this does not help
Refer if these can help
Thanks @amitchandak do you mean unpivot on the category and value column (there are not too many categories - 17). When i try this I don't get the results I expect. I will look at the links you sent, thank you.
Sorry @Greg_Deckler yes, I sent that in desperation after staring at it for hours....I would like the category repeating items to be columns and region/year/level/POLAR/category etc to be filters or nested row labels.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.